I see...OK...trying the <cfqueryparam now. Getting "?" inserted into my database. Must be wrong syntax. I'll keep trying.
On Thu, 31 Oct 2002 11:53:38 -0600, Paul Giesenhagen wrote: > \ 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
