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
