What is causing Microsoft Access ODBC Error - "Syntax error in update statement"?
I am not a programmer. I am using Dreamweaver to update (edit) a dynamic table on my website.
I cannot seem to figure out what is wrong with the code. Please see the attached Word document for the error message and the code that Dreamweaver filled in for me. I hi-lited in yellow the line of code that the error message refers to.
Any help in resolving this issue would be greatly appreciated.
Thank you...
Rick
ERROR-MESSAGE.doc
I cannot seem to figure out what is wrong with the code. Please see the attached Word document for the error message and the code that Dreamweaver filled in for me. I hi-lited in yellow the line of code that the error message refers to.
Any help in resolving this issue would be greatly appreciated.
Thank you...
Rick
ERROR-MESSAGE.doc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This error is normally caused by not having a valid selection in the drop down list, which would be prospect list in this error.
ASKER
I do not have any drop down lists. The name of my table that I am updating is called "ProspectList."
To update the table the client selects the line on the table to update and clicks the hyperlink.
The hyperlink passes the LineId to the update table page. (The code you are looking at).
Once the client types in the change on this page, they hit the submit button which is supposed to update the Access Table and then redirect the client back to the beginning page to see that the change was made.
Not sure if this will help you.
let me know.
thank you...
Rick
To update the table the client selects the line on the table to update and clicks the hyperlink.
The hyperlink passes the LineId to the update table page. (The code you are looking at).
Once the client types in the change on this page, they hit the submit button which is supposed to update the Access Table and then redirect the client back to the beginning page to see that the change was made.
Not sure if this will help you.
let me know.
thank you...
Rick
ASKER
Thank you very much for your help.
I figured out the second error. (The url address was incorrect) I made the change and the web page works fine.
Again thank you for the one line of code.
Rick
I figured out the second error. (The url address was incorrect) I made the change and the web page works fine.
Again thank you for the one line of code.
Rick
No problem
ASKER
Hi-lited in blue is what it does not like.
Thank you...
Rick
ERROR-MESSAGE.doc