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
