RE: The '&' problem in XML packet
Since no XML document can contain a bare ampersand, if your database tells you it is returning XML and what it returns contains bare ampersands, then your database's XML production facility is broken. If you can't get them to fix it, you have two choices: 1) Capture the database output in a VARCHAR2 and use the database's procedural language (for SQL Server, it's T-SQL, for Oracle and PostgreSQL it's PL/SQL, I don't know anything about others), to process the string, replacing the bare ampersands with & before you try to parse it. 2) Create SQL statements that update every column in every row in every table you work with to do the substitution and then put triggers on insert and update for those tables that do the substitution whenever the data is changed. -- Charles Knell cknell@xxxxxxxxxx - email -----Original Message----- From: asim <qazi@xxxxxxxxxxx> Sent: Sat, 1 Nov 2003 09:21:02 +0500 To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> Subject: The '&' problem in XML packet Hi All I querry a database table and make a XML packet dont know which field can contain '&' .. what should i do so that my parser should not break will parsing .... Qazi Asim XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format