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

[Bob Stone <bstone@fastenal.com>]

are you sure that it's the SQR which changes what it outputs and not the
file viewer you're using?  Some viewers read characters like '&' to '&'
automatically.

Another possiblity is that there needs to be a meta-character to leave the &
alone.  You know when you have something like \\ to write out a single slash
in some languages (like java) because \ expects something like \n or \t for
newline or tab (unix)??  maybe you need something like that?  SQR might be
interpretting the & as a 'do-something' character rather than a 'print this'
character.  

hope this helps (in spite of my lack of vocab on my explaination)


-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
harriaj@NU.COM
Sent: Tuesday, December 14, 2004 12:20 PM
To: This list is for discussion about the SQR database reporting
language from 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