Post reply

unwanted character changes

  • September 5, 2007 at 11:53 am

    #373732

    I'm querying SQL 2005 table with FOR XML AUTO, ELEMENTS.

    This field has a lot of HTML code.

    Example:

    • bullet 1
    • bullet 2
    • bullet 3

    ...comes out like...

    <ul>

    <li>Bullet 1</li>

    <li>Bullet 2</li>

    <li>Bullet 3</li>

    </ul>

    "&" are converted to &

    I realize a browser will read them correctly, but I prefer they remain

    intact.

    How can I stop that? Do I have to replace statements?

    thanks

  • September 6, 2007 at 3:55 am

    #731749

    I do not think you can do this. One nice thing about FOR XML is that it produces well-formed XML . Having an & in the XML that is not entitised will make the XML fragment no longer well-formed.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply