I ran into this trying to store file paths in text fields. Turns out this is documented, deliberate behavior for mySQL (I have no idea why). You have to insert a double backslash, and then you'll get a single one actually stored.
I do this just before an insert: <CFSET form.LiveImagePath=Replace(form.LiveImagePath,"\","\\","ALL")> --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 7:45 AM To: CF-Talk Subject: Re: mySQL and backslash > 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!!) Well... You could just use 92 and then at the top of a given page set the delimiter to the correct value, i.e. <cfset request.fsdelim = chr(myquery.fsdelim)> ... though that's neither here nor there now that you've already got the whole system set up the way it is... Wish I could help with the db issue -- I'm not familiar with mySQL personally... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
