I have been working on trying to build a website through Dreaweaver that is also working in conjunction with Coldfusion. I have added a new record set to update a job listing through a Access database. Whenever I submit the new entry I am getting the fallowing error.

Error Occurred While Processing Request
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:\CFusionMX7\wwwroot\Admin\Add Career.cfm: line 59

57 : No
58 : </cfif>
59 : WHERE JobID=#FORM.JobID#
60 : </cfquery>
61 : <cflocation url="Careers List.cfm">



--------------------------------------------------------------------------------

SQL UPDATE Career SET JobTitle= NULL , Location= 1 , Position= 3 , Descripton= NULL , Requirements= NULL , Experiance= NULL , Application= NULL , Date= NULL , Online= No WHERE JobID=
DATASOURCE barney_trucking
VENDORERRORCODE -3503
SQLSTATE 42000

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Remote Address 127.0.0.1
Referrer localhost:8500/Admin/Add%20Career.cfm
Date/Time 01-Oct-06 09:45 PM

Stack Trace (click to expand)



If anyone could tell me how to fix this or point me in the right direction to start looking I will gladly read all I have to to find the answer out to this fix. I thank eveyone for there time and responses!