Hvad er der galt med denne INSERT sætning?
Cols=\"[Posted], [Author], [Headline], [Mention], [Publicationnr], [Content]\"Vals=\"\'\"&Posted&\"\',\"
Vals=Vals & \"\'\"&Author&\"\',\"
Vals=Vals & \"\'\"&Headline&\"\',\"
Vals=Vals & \"\'\"&Mention&\"\',\"
Vals=Vals & \"\'\"&Publicationnr&\"\',\"
Vals=Vals & \"\'\"&Content&\"\'\"
SQL = \"INSERT INTO Articles(\" & Cols & \") VALUES (\"& Vals & \");\"
Con.Execute SQL
Fejlmelding på PWS:
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/admin.asp, line 28, column 15
Vals=Vals & \"\'\"&Headline&\"\',\"
mvh
Søren Peter
