I am not able to retrive proper data using the for XML path from SQl.
If I have inserted data as <![CDATA[London]]> in table and, when i write select using for xml, it gives me error as
XML parsing: line 5, character 75, illegal name character
Please mark this post as Answer if it is of help to you!
I would love to change the world, but they wont give me the source code.
kavita_khand...
Star
9767 Points
1931 Posts
Problem in using & using in CDATA
Mar 20, 2012 10:10 AM|LINK
I am not able to retrive proper data using the for XML path from SQl.
If I have inserted data as <![CDATA[London]]> in table and, when i write select using for xml, it gives me error as
XML parsing: line 5, character 75, illegal name character
I would love to change the world, but they wont give me the source code.