Syntax Error upon Database Update
Posted on 2006-05-01
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
The error occurred in C:\XXXXX\XXXXX\XXXXX\IXXXXX\page3.cfm: line 14
12 : <CFQUERY datasource="AnyOldDatabase">
13 : UPDATE INTO tblNewUser (CloneOrList1, OtherOptions1, Printer1)
14 : VALUES ('#FORM.CloneOrList1#','#FORM.MoreOptions1#','#FORM.DefaultPrinter1#')
15 : </CFQUERY>
I am getting this error upon submitting the page2.
Just a little background info:
I have created an Access database table named tblNewUser. I have 5 .cfm pages that need to populate the database table. Page one asks the user the normal firstname, lastname stuff, then the user submits page1, and page2 has a query looking for all the FORM names from the page1, and populates tblNewUser with the desired information. More questions are asked on page2 and upon submit I want to continue populating the same recordID with more information. Page2 usesthe syntax "INSERT INTO tblNewUser (FirstName, LastName,.....)" and it works just fine. I figured I would use "UPDATE INTO", or just plain "UPDATE" for page 3, but then I get the error above. When I check to tsee if IE has grabbed all the pertinent FORM information from page2 after submit, I see that it has, but will not update the database with that information, plus I get the error message.
What am I doing wrong????? I made sure all the form names were unique. I removed "INTO". I made sure there were no spaces in the table name. I changed UDPATE back to INSERT, and it works, except it puts all this information in a new recordID. But at least I know that the syntax is pretty close. The answer is probably right under my nose.
Thanks for the help.