Its defo a mySQL thing i'm sure...
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 13 August 2002 15:24 To: CF-Talk Subject: Re: \" in a WDDX mySQL 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 > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
