Did you try URL encoding the quotation mark? That might solve it?
____________________________________________________
Kaustav Acharya
Web Developer
U. Inc.
12250 El Camino Real, Suite #100
San Diego, CA. 92130
Office: (858) 847-3350 x1004
Fax: (858) 847-3340
email: kacha...@colleges.com
http://www.colleges.com
____________________________________________________
Power to the People - http://www.campaign.com
____________________________________________________
Important Note: This e-mail may contain privileged, undisclosed or
confidential information. If you have received this e-mail in error,
you are hereby notified
that any review, copying or distribution of it is strictly
prohibited. Please inform kacha...@colleges.com Immediately and
permanently destroy the original transmittal.
On Feb 23, 2009, at 3:11 PM, Bill Downall wrote:
Hello, all.
I have a process that is reading an xml file and setting up data in
a database as a result. Rarely, text data has an embedded double-
quote mark in it, and often it has embedded single-quote marks in
it. The single-quotes take care of themselves with SQL encoding,
but what can I do about the double-quotes?
This assignment sets a variable from the XML tree:
<@assign request$note <@elementValue object=request$inputDOM
element="<@var request$node>.child(1,Weather).child(1,Note)">>
Which acts like the equivalent of this:
<@assign request$note value='We had an 8" snowfall last night.'>
But the variable never gets set, and the rest of the code fails
while Witango's parser looks for the closing double-quote. I don't
even have the value in a variable so that I can replace the " with
<@dq>.
Any clever solutions out there? Thanks
Bill
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf