You have to escape the \ with \\.  Don't ask why, I have no clue.

On Tue, 13 Aug 2002, Paul Giesenhagen wrote:

> Ok, I have a mySQL database and I am trying to stick a WDDX packet into a LONGTEXT 
>field
> The problem is when I stick a backslash "\" into a THISVALUE2 (and it is the only 
>value), mySQL removes it when I insert or update the record.
> 
> Does anyone know why this is the case?  I need to have the "\" it is a directory 
>delimiter preference that is used throughout the site.  Thus I cannot use chr(92) 
>(plus it doesn't work either!!)
> 
> (Note the forward slash / works just fine)
> 
> Here is the WDDX packet
> 
> <wddxPacket version='1.0'>
>     <header>
>     </header>
>         <data>
>             <struct>
>                 <var name='THISVALUE'>
>                     <string>1</string>
>                 </var>
>             <var name='THISVALUE2'>
>                     <string></string>  <!--- this should be <string>\</string>
>             </var>
>             <var name='THISVALUE3'>
>                 <string>/</string>
>             </var>
>         </struct>
>     </data>
> </wddxPacket>
> 
> Paul Giesenhagen
> QuillDesign
> 
> 
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to