Syntax error in INSERT INTO statement.

I am receiving the follwing error with ColdFustion Server MX7. The scripts were written in ColdFusion 5. Has something changed?

Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

The error occurred in K:\web\fsd145\fsdadmin\event_addAction.cfm: line 15

13 : </td></table></body></html>
14 : <cfelse>
15 : <cfinsert datasource="dbase" tablename="events">
16 : <cfoutput>
17 : <table width="50%">



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

SQL insert into events (NAME,TIME,YEAR,MONTH,DETAILS,LOCATION,SUMMARY,DAY ) values ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) )
DATASOURCE dbase
VENDORERRORCODE -3502
SQLSTATE 42000

Please try the following:

I ahave the same problem anybody knows the solution

Thanks

I guess the database is changed between versions.
If so, there is not much else to do than updating the script to version MX7

I believe "name" is a reserved name that will often cause errors, so you may want to rename your fields with a prefix like eventName, eventDate, etc.

Here's some more technical info: http://www.macromedia.com/go/14622

Was Stumped with the exact same message... I couldn't understand why. I had changed my Table Field Names to simple names. ie Name, Date, ect....

Just Change the field names in you Database... Duh!

After Reading the above thread. This resolved my errors. Thank You!!!!!!!!!!!!!!!!!!!

'update' is a reserved word in access
'update' is a reserved word in access
'update' is a reserved word in access
'update' is a reserved word in access
'update' is a reserved word in access
...

i won't forget that in a hurry. 2hrs down the drain.

THANKING YOU!