Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

xml/xsl double quote sql server

Status
Not open for further replies.

spirit66

Technical User
Apr 10, 2004
29
US
Hi,
I have an xml string which i do send it as a parameter for a sql stored procedure .
The issue i'm facing is , i need to send a double quote around a value .but when i send that
through xml/xsl it converts it into a double quote even before it reaches sql server and it gives an error
in the sql stored procedure since the input string is not a well formatted xml string .

here is an example .

This works if i run from sql server -query analyzer .
Code:
exec de.sp_proc @xmltxt='<look><id="1" VAL="&quot;yahoo&quot;"/></look>
but when i try to send that &quot; from xml/xsl it converts to double quote and gives error
in stored procedure .

Any help greatly appreciated .

Thanks
 
I did find out after some search on the Internet to user
&#8220; for left double quote and &#8221; for right double quote .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top