Skip to main content
A
Anonymous
October 17, 2009
Answered

CF5 form will not execute in CF8 - Any thoughts?

  • October 17, 2009
  • 1 reply
  • 2057 views

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 😎 , (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: 
This topic has been closed for replies.
Correct answer Ken_Ford_-_ACP-QFo4AB
Only thing I can think of is reserved word DATE:
http://support.microsoft.com/kb/286335
Ken Ford
1 reply
Ken_Ford_-_ACP-QFo4AB
Ken_Ford_-_ACP-QFo4ABCorrect answer
Inspiring
October 18, 2009
Only thing I can think of is reserved word DATE:
http://support.microsoft.com/kb/286335
Ken Ford
A
Anonymous
October 18, 2009
Ken you are a lifesaver. That was it! Thanks!
Ken_Ford_-_ACP-QFo4AB
Ken_Ford_-_ACP-QFo4AB
Inspiring
October 18, 2009
LOL pretty good stab in the dark ;-)
Ken Ford

        
                                                

        

    


            

                                        

            
                        

                                                                                                            
            




        

                    

    
    





    


                                        

                                                        

            
        
    






                                    
Terms & ConditionsAccessibility statement

            
        



        
            
    
        
    
        



        
        
        


        


        
        
        
        
                                                        

                            
    

                    

  

    

      
        
      
    

    

      
        Using the community
      
      
        Terms of use
      
      
        Privacy
      
      
        Cookie preferences
      
      
        Do not sell or share my personal information
      
      
        ad choicesAdChoices