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:2418
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
