[cfaussie] Single Quote insert into SQL

Thu, 26 Jun 2003 17:54:43 -0700 

Hi All,

On my development box (Win XP, MX updater-3, SQL 2000) if I run

<cfquery name="Update_Test" datasource="#DSN#" dbtype="ODBC">
  update  mytest
  set        mytest_comment = '#form.mytest_comment#'
  where   testid     = #my_id#
</cfquery>

and the form field contains a single quote, it works fine.

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.

[Macromedia][SQLServer JDBC Driver][SQLServer]Line 8: Incorrect syntax near
'B'.

update ...
set...
mytest_comment = &apos;&apos;&apos;
...
where ...

Any thoughts on what setting is different on the server?

Thanks,
Phil.


---
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/

Reply via email to