Special Character inside XML string data

[Norman Uhlenkott]

I would like to be able to put in special character inside
an xml data string (#, <, >, &).
when it trys to parses out the XML String it errors out

strXML = "<?xml version='1.0'?>" & vbCRLF
strXML = strXML + "<WO_Step>" & vbCRLF
strXML = strXML + "<Test>Test Special Characters #, %, &,
<, > </Test>
strXML = strXML + "</WO_Step>"

What is the best way to pass this type of information?
Would changing the encoded of the XML string work.

 

[Ayende Rahien]

I would like to be able to put in special character inside
an xml data string (#, <, >, &).
when it trys to parses out the XML String it errors out

strXML = "<?xml version='1.0'?>" & vbCRLF
strXML = strXML + "<WO_Step>" & vbCRLF
strXML = strXML + "<Test>Test Special Characters #, %, &,
<, > </Test>
strXML = strXML + "</WO_Step>"

What is the best way to pass this type of information?
Would changing the encoded of the XML string work.

No, you can't store it this way, use XmlWriter.

 

[vMike]

You could try somthing like this. I think it will work.
<![CDATA[somedatahere&moredatahere]]> for example

 

[vMike]

Let me clarify that a bit more. the somedatahere and the moredatehere is
straight text. The example would add the literal "somedatahere&moredatahere"

You could try somthing like this. I think it will work.
<![CDATA[somedatahere&moredatahere]]> for example

I would like to be able to put in special character inside
an xml data string (#, <, >, &).
when it trys to parses out the XML String it errors out

strXML = "<?xml version='1.0'?>" & vbCRLF
strXML = strXML + "<WO_Step>" & vbCRLF
strXML = strXML + "<Test>Test Special Characters #, %, &,
<, > </Test>
strXML = strXML + "</WO_Step>"

What is the best way to pass this type of information?
Would changing the encoded of the XML string work.

 

[Alan Pretre]

I would like to be able to put in special character inside
an xml data string (#, <, >, &).
when it trys to parses out the XML String it errors out

For the following special chars in the 1st column use the sequences in the
2nd column.
& &amp;
< &lt;

&gt;

" &quot;
' &apos;

strXML = strXML + "</WO_Step>"

For example,
strXML = strXML + "&lt;/WO_Step&gt;"

-- Alan