Use cfqueryparam, that will escape the single quotes for you.. Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ 0421 851 786 Tell me and I will forget Show me and I will remember Teach me and I will learn
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Jason Bayly > Sent: Thursday, 22 January 2004 8:53 AM > To: CFAussie Mailing List > Subject: [cfaussie] CFMX not escaping single quotes > > > Hi all > > I'm getting repeated syntax errors on an insert statement > that has to do with a single quote appearing in a string. In > the past ive never had to worry about single quotes in a > string cause i thought CF automatically escaped them in a > query. Am i incorrect here ? > > heres part of the debug msg... any one got a good method to > ensure this doesnt happen ?? > > ODBC Error Code = 37000 (Syntax error or access violation) > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 161: > Incorrect syntax near 's'. > > VALUES ( '38 Taylor Street', '', 'Toowoomba', 'St Ursula's College', > > > > cheers > jason > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
