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

Reply via email to