no comma after live=0
----- Original Message -----
From: "Darren Adams" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 9:52 AM
Subject: Syntax error or sharing violation
> can anyone here see what the problem with this statement is ?
>
>
> <cfquery name="news" datasource="cosmos1" dbtype="ODBC">
> UPDATE waiting_room_news
> set
> headline = '#headline#',
> subtitle = '#subtitle#',
> body = '#body#',
> author = '#author#',
> expdate = '#expdate#',
> <cfif #audience# EQ 'Keep old value'> audience = '#oldaudience#' <cfelse>
> audience = '#audience#' </cfif>,
> datestamp = '#date#',
> <!---Set the approval field back to 0 --->
> live = 0,
> where id = #id#
> </cfquery>
>
>
> This is the error message I am getting:
>
> Error Occurred While Processing Request
> Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or
access
> violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in
UPDATE
> statement. The error occurred while processing an element with a general
> identifier of (CFQUERY), occupying document position (20:1) to (20:56).
> Date/Time: 04/26/01 14:50:44 Browser: Mozilla/4.0 (compatible; MSIE 5.0;
> Windows 95; DigExt) Remote Address: 129.153.207.20 HTTP Referer:
> http://uk1web2:8080/menutest/authorise/edit_news.cfm?id=5&country=World
> Wide&&content=news Template:
> E:\Inetpub\publicsite\menutest\authorise\edit_news_action.cfm
>
>
>
>
> Darren Adams
> Web Developer
> Marketing Department
> Systems Union
>
> Office: 01252 55 6220
> Mobile: 07714 817 038
> Email: [EMAIL PROTECTED]
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
