I would recommend using it highly. I wouldnt be surprised if mySql was escaping something for you. using cfqueryparam will usually avoid this type of issue.
DRE -----Original Message----- From: FlashGuy [mailto:flashmx@;rogers.com] Sent: Thursday, October 31, 2002 10:55 AM To: CF-Community Subject: RE: MySQL & CF Sorry, I'm new at this SQL stuff. Are you saying I have to change all my <cfquery which I used for the Access databases to <cfqueryparam for MySQL? On Thu, 31 Oct 2002 10:53:02 -0700, Andre Turrettini wrote: > are you using cfqueryparam? > > -----Original Message----- > From: FlashGuy [mailto:flashmx@;rogers.com] > Sent: Thursday, October 31, 2002 10:47 AM > To: CF-Community > 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=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
