That's a feature, not a bug ;D. mySQL uses the backslash character as its beginner for native escape sequences, which you can pretty much ignore on balance.
http://www.mysql.com/doc/S/t/String_syntax.html So, as you've probably already figured out, you need to use \\ for a \ in your input. I use a replace function on vorm vars just prior to insertion when users are entering windos pathnames and such. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -----Original Message----- From: Neil Clark =TMM= [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 2:04 AM To: CF-Talk Subject: RE: MySQL error with myODBC drivers Hi Stephen. Turns out that mySQL was freaking with \ in a fieldname : I have to enter a path i.e. c:\blah\blah I had to escape the \ to get it work. I think it is a problem with the ODBC drivers as it is a pretty straightforward SQL action. Very strange indeed. Neil ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
