Thanks Tim. I could code around the issue, and your suggestion is no doubt a great place to start.
However I would have a lot of code to check through and modify, and was really hoping to find the magic switch that enables it to keep working just the way it always has. Any ideas? Thanks, Phil. ----- Original Message ----- From: "Tim" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 11:06 AM Subject: [cfaussie] Re: Single Quote insert into SQL > Try: > > <cfquery name="Update_Test" datasource="#DSN#"> > update mytest > set mytest_comment = <cfqueryparam > value="#form.mytest_comment#" cfsqltype="cf_sql_varchar" /> > where testid = #my_id# > </cfquery> > > Change the sqltype accordingly. > > - tim > > Phil Evans spoke the following wise words on 27/06/2003 10:55 AM EST: > > >However, I've just migrated the site to a new server, Win 2000, MX (updater > >unknown), SQL 2000 and if a user enters a single quote in a comment, it spits. > > > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
