CF5 form will not execute in CF8 - Any thoughts?

[Guest]

I am working with a form that works when tested on my CF5 server but generates the following error when executed on my CF8 server. I have attached the code for the form below (I stripped it down quite a bit...sorry its so lengthy) I am hoping someone can point me in the right direction based on the server circumstances and the error message. Thanks in advance!

Here is the error message:

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

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 D:\Inetpub\mannapremier\mp_order_form2.cfm: line 4 2 : 3 :  4 : <cfinsert datasource="manna_premier" tablename="Orders"> 5 : 6 : <cflocation url="mp_order_form3.cfm?ID=#FORM.DealerID#"> SQLSTATE   42000 SQL   insert into Orders (COMMENTS1,BAGSCASES1,BAGSCASES2,BAGSCASES3,BAGSCASES4,BAGSCASES5,BAGSCASES6,BAGSCASES7,DEALERID,BAGSCASES9,BAGSCASES8,VARIABLE,QUANTITY12,QUANTITY13,NEWEXISTING11,QUANTITY14,NEWEXISTING10,QUANTITY15,NEWEXISTING13,NEWEXISTING12,QUANTITY10,NEWEXISTING15,QUANTITY11,NEWEXISTING14,NEWEXISTING16,NEWEXISTING17,NEWEXISTING18,NEWEXISTING19,QUANTITY17,QUANTITY16,QUANTITY19,QUANTITY18,QUANTITY8,QUANTITY7,PRODUCT1,QUANTITY9,QUANTITY4,QUANTITY3,QUANTITY6,NEWEXISTING20,QUANTITY5,QUANTITY2,QUANTITY1,BAGSCASES12,BAGSCASES11,BAGSCASES14,BAGSCASES13,BAGSCASES16,BAGSCASES15,BAGSCASES18,BAGSCASES17,BAGSCASES10,ISOCHECKAMOUNT,TERRITORYMANAGER,NEWEXISTING2,NEWEXISTING1,NEWEXISTING4,NEWEXISTING3,NEWEXISTING6,NEWEXISTING5,NEWEXISTING8,NEWEXISTING7,NEWEXISTING9,DISTRIBUTOR,ISOCHECK,CALLBACK,ISOCHECKNUMBER,PONUMBER,BAGSCASES19,DATE,BAGSCASES20,QUANTITY20) values ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) , (param 18) , (param 19) , (param 20) , (param 21) , (param 22) , (param 23) , (param 24) , (param 25) , (param 26) , (param 27) , (param 28) , (param 29) , (param 30) , (param 31) , (param 32) , (param 33) , (param 34) , (param 35) , (param 36) , (param 37) , (param 38) , (param 39) , (param 40) , (param 41) , (param 42) , (param 43) , (param 44) , (param 45) , (param 46) , (param 47) , (param 48) , (param 49) , (param 50) , (param 51) , (param 52) , (param 53) , (param 54) , (param 55) , (param 56) , (param 57) , (param 58) , (param 59) , (param 60) , (param 61) , (param 62) , (param 63) , (param 64) , (param 65) , (param 66) , (param 67) , (param 68) , (param 69) , (param 70) , (param 71) , (param 72) ) VENDORERRORCODE   -3502 DATASOURCE   manna_premier Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem.

[Ken_Ford_-_ACP-QFo4AB · Accepted solution]

Only thing I can think of is reserved word DATE:

http://support.microsoft.com/kb/286335

Ken Ford

[Guest]

Ken you are a lifesaver. That was it! Thanks!

[Ken_Ford_-_ACP-QFo4AB]

LOL pretty good stab in the dark 😉

Ken Ford