Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Unanswered: How to Represent

    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.

  2. #2
    Join Date
    Dec 2002
    Location
    BELGIUM
    Posts
    18
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •