[sqr-users] writing XML special codes from SQR

[harriaj@NU.COM]

* I am writing an SQR to generate an XML file.

* Some of the data we have has lots of ampersands.

* The program reading the XML requires any ampersands to be written as
&.

* As I read in the column I am translating all the ampersands -- using the
replace function -- to &.

* Using the show statement, I can see in the log that all the ampersands
are being properly translated.

* When I write the variable to the file, SQR is being a little too clever;
it is translating all the occurrences of & back to ampersand.

* How do I tell SQR: "no, no, leave the & as it is."?


Andrew :)
Reporting Hero
X 3523



**********************************************************************
This e-mail, including any files or attachments transmitted with it, is 
confidential and intended for a specific purpose and for use only by the 
individual or entity to whom it is addressed.  Any disclosure, copying or 
distribution of this e-mail or the taking of any action based on its contents, 
other than for its intended purpose, is strictly prohibited.  If you have 
received this e-mail in error, please notify the sender immediately and delete 
it from your system.  Any views or opinions expressed in this e-mail are not 
necessarily those of Northeast Utilities, its subsidiaries and affiliates (NU). 
 E-mail transmission cannot be guaranteed to be error-free or secure or free 
from viruses, and NU disclaims all liability for any resulting damage, errors, 
or omissions.
**********************************************************************


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users