----- Original Message -----
From: Robert Orlini
To: CF-Talk
Sent: Friday, March 12, 2004 2:45 PM
Subject: Incorrect syntax near...
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]
