How to Pass Reserved Characters as Data in XML
Description
How to pass XML reserved characters (&, <, >, ",') as XML data in Loftware
Requirements
-
MS-XML Parser Version 3.0 or higher (included with Internet Explorer 6.0 and higher)
How to Pass Reserved Characters in XML
-
XML substitution formats are as follows:
CopyXML sample<pre class="syntaxhighlighter-pre" xml:space="preserve">Ampersand (&): &
Less than (<): <
Greater than (>): >
Quote ("): "
Apostrophe ('): '
</pre> - Example
The data string "Ben & Jerry's" would look like: <variable name=Company>Ben & Jerry's</variable>
Note
Loftware has adopted Microsoft's XML Parser rules as of 8.3 and newer. Some characters that you could pass without interpretation using Loftware's rules in version 7.x will not work in 9.x. Here is a Microsoft Technical link regarding XML parsing:
https://technet.microsoft.com/en-us/library/ms145315(v=sql.90).aspx
Article Number
2016066
Versions
Loftware Version 8.3 or higher
Environment
Any supported LPS family product environment