\ is an escape character .. .Matt Robertson gave me a good tip .. use <cfqueryparam> for your insert and let CF escape all the correct characters.
Hope this helps. Paul Giesenhagen QuillDesign ----- Original Message ----- From: "FlashGuy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 11:46 AM Subject: OT: MySQL & CF > Hi, > > Something weird is happening. Before I switched my databases from Access to MySQL my app was working OK. > Now when I insert data into my SQL database one of the fields is getting mucked up and I don't know why? Here is an example of a entry how is *should* appear in the > database: > > Should be: > > env_var = book1 > destination = D:\data\book1 > > This is what getting input into my SQL database: > > env_var = book1 > destination = D:|ata|ook1 > > Its like the "\b" is getting interpreted into a wacko ASCII character? > > Both fields in my table are varchar(255) types > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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