How to Represent [Archive]

Vijayalakshmi_m

12-19-02, 06:19

Dear All,
I'm using an xml to store the details of a report. Now i'm supposed to store an sql statement in that xml. Can anyone suggest me, how to represent this sql in my xml file. If i have this sql as an attribute, i've to look into some special characters like >,< etc..
Is there any way to solve this problem.

Looking forward...

Cheers,
Viji.

tomaski

12-22-02, 12:07

Hi Viji,

When your data contains characters like < or >, you can let the xml parser ignore them by using the keyword CDATA:

<xmldatablock>
<![CDATA[
select * from mytablename where rowid > 100 and rowid > 105;
]]>
</xmldatablock>

regards,
Benny Lootens
Java Developer
BELGIUM