Incorrect syntax near...

[Robert Orlini]

In this SQL script below I get the following error: "Incorrect syntax near '='." I've tried #form.custommessage# in single quotes, double quotes and no quotes, but still it won't work though it displays the text in the debug. This is the error above "ODBC Error Code = 37000 (Syntax error or access violation)"
It seems simple. Please help.
Robert O.
HWW
<CFif #form.custommessage# NEQ "">
<cfquery name="Updatestatus" datasource="wweb_status">
Update wweb_status
SET status = 'custom'
SET custom_message = #form.custommessage#
Where status = status
</cfquery>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---