RE: [sqr-users] writing XML special codes from SQR

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

By any chance, are you writing it as follows:

write 1 from $item:1 ....

That would only output the first character of "&amp".

-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org]On
Behalf Of harriaj@NU.COM
Sent: Tuesday, December 14, 2004 10:20 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: [sqr-users] writing XML special codes from SQR


* 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

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