Ditch the last comma before the WHERE clause. > -----Original Message----- > From: Chris Boyce [mailto:[EMAIL PROTECTED] > Sent: Friday, January 12, 2007 10:33 AM > To: CF-Newbie > Subject: Syntax error in UPDATE statement > > Hi everyone, > > > > I am getting an annoying error: Syntax error in UPDATE statement > > (error message highlights the WHERE clause) > > > > This is the query: > > > > <cfquery datasource="cf_obliqstudy" name="q2Process"> > > UPDATE questionnaire > > SET q2_f = #FORM.q_2_f#, > > q2_p = #FORM.q_2_p#, > > q2_e = #FORM.q_2_e#, > > q2_n = #FORM.q_2_n#, > > q2_comment = '#FORM.q_2_comment#', > > WHERE Participant_ID = #FORM.Participant_ID# > > </cfquery> > > > > - For the moment I have removed the <cfqueryparam> tags, with them included, > the error is no different. > > - If I remove the where clause (which is highlighted as the error) The line > above becomes highlighted in the error message, and so on. > > - The DSN has update rights enabled. > > - It is an Access DB > > - Text fields are in quotes, number fields are not > > - I have checked and double checked all field, form names are correct > > - I have done a CF dump on the same page as the query to ensure all FORM > Elements are available to the query. > > > > What else do I do? I have rewritten this query a whole bunch of times and I > still get the same error. > > > > Thanks in advance for any help/advice someone may have > > > > Chris > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2419 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
