Update wweb_status
SET status = 'custom',
custom_message = #form.custommessage#
Where status = status
-Cameron
-----------------
Cameron Childress
Sumo Consulting Inc
---
land: 858.509.3098
cell: 678.637.5072
aim: cameroncf
email: [EMAIL PROTECTED]
-----Original Message-----
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 11:45 AM
To: CF-Talk
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]
