Syntax fejl
Jeg får denne fejl, og jeg kan ikke finde fejlen:Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/kursuscenter/konkurrence_svar.asp, line 59
Min sætning ser sådan ud:
strSQL = "Insert Into Konkurrence (Spg1, Spg2, Spg3, Spg4, Spg5, Navn, Firma, Adresse, Postnummer, By, Telefon, Email, Stilling, SpgA, SpgB, SpgC, Bemærkning, Dato) VALUES('" & Request.form("sp1") & "', '" & Request.form("sp2") & "', '" & Request.form("sp3") & "','" & Request.form("sp4") & "','" & Request.form("sp5") & "','" & Request.form("name") & "','" & Request.form("Firma") & "', '" & Request.form("Adresse") & "',"& Request.form("Postnummer") & ",'" & Request.form("By") & "','" & Request.form("Telefon") & "', '" & Request.form("email") & "','" & Request.form("Stilling") & "','" & Request.form("spgA") & "','" & Request.form("spgB") & "','" & Request.form("spgC") & "','" & Request.form("note") & "', '" & Now() & "')"
cn.Execute(strSQL)