Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2004
    Posts
    5

    Unanswered: XML Entities not formatting right

    Hey all,
    I was just wondering what I have to do to handle XML entities properly

    IE: I have a query

    SELECT Name FROM users FOR XML AUTO;

    and the return data looks like:

    <users Name="John & Sara"/>

    however you can see the & symbol isn't converted to &amp;

    any ideas on this one? thanks!
    Last edited by recchi_8; 07-19-04 at 17:36.

Posting Permissions

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