error code

[gmag47]

I got this error code can someone explain why?

Error Type:
Microsoft VBScript compilation (0x800A0400)
Expected statement
/new web site/pol/HCMAP/DEU.asp, line 125
" ',' " & var7 & " ',' " & var8 & " ',' " & var9 & " ',' " & var11 & " ',' " & var12 & " ', 1," & " ',' " & var13 & " ',' " & var14 & " ',' " & var15 & _



set DEU = Server.CreateObject("ADODB.Command")
DEU.ActiveConnection = MM_HCMAP_STRING
DEU.CommandText = "INSERT INTO DEU_Certification VALUES ( ) "
" ',' " & var7 & " ',' " & var8 & " ',' " & var9 & " ',' " & var11 & " ',' " & var12 & " ', 1," & " ',' " & var13 & " ',' " & var14 & " ',' " & var15 & _
" ',' " & var16 & " ',' " & var17 & " ',' " & var18 & " ',' " & var19 & " ',' " & var20 & " ',' " & var21 & " ',' " & var22 & " ', ' " & var23 & _
" ',' " & var24 & " ', ' " & var25 & " ', ' " & var26 & " ', ' " & var27 & " ', ' " & var28 & " ', ' " & var29 & " ', ' " & var30 & _
" ',' " & var31 & " ', ' " & var32 & " ', ' " & var33 & " ', ' " & var34 & " ', ' " & var35 & " ', ' " & var36 & " ', ' " & var37 & " ', ' " & var38 & " ', ' " & var39 & " ', ' " & var40 & " ')"

DEU.CommandType = 1
DEU.CommandTimeout = 0
DEU.Prepared = true
DEU.Execute()


%>

[chrismartz]

try

"INSERT INTO DEU_Certification VALUES ( ) " &_

Also, where are these suposed to get inserted into?

[Nicodemas]

Looks like he is using the default insert fields of the table. If you leave out the field list, it will default to all fields, in the exact same order as they appear.

[chrismartz]

I'm just guessing but I don't believe that he has 40 different fields!