That is correct ... and that is a BAD thing (i guess it is bad in my eyes only :)... so I cannot write a value of c:\inetpub\whatever\directory\with\slashes using mySQL?
I guess mySQL uses the backslash as an escape character (per their docs). Too bad, that makes some things very difficult! MS SQL takes both the \ and \\ and represents them as \ and \\ which is going to make things tough for a distributed application. Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Robertson-Ravo, Neil (REC)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 9:26 AM Subject: RE: \" in a WDDX mySQL > 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 > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
