Fejl i SQL-insert
HejstrSQL = "Insert into bestilling (dato, vare, fornavn, efternavn, adresse, post, by, telefon, email, varighed, domain, ovrig)"
strSQL = strSQL & " values('" & dato & "', "
strSQL = strSQL & "'" & Request.Querystring("id") & "', "
strSQL = strSQL & "'" & Request.Form("fornavn") & "', "
strSQL = strSQL & "'" & Request.Form("efternavn") & "', "
strSQL = strSQL & "'" & Request.Form("adresse") & "', "
strSQL = strSQL & "'" & Request.Form("post") & "', "
strSQL = strSQL & "'" & Request.Form("by") & "', "
strSQL = strSQL & "'" & Request.Form("telefon") & "', "
strSQL = strSQL & "'" & Request.Form("email") & "', "
strSQL = strSQL & "'" & Request.Form("varighed") & "', "
strSQL = strSQL & "'" & Request.Form("domain") & "', "
strSQL = strSQL & "'" & Request.Form("ovrig") & "')"
Conn.Execute(strSQL)
Fejl:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Mvh.
Lange
