> -----Original Message-----
> From: Robert Orlini [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 12, 2004 2:45 PM
> 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]
