Kan ikke finde min fejl
Hey... er der en venlig sjæl som kan finde min fejl? for jeg har set mig blind :(kode:
strSQL = "insert into parts ("
strSQL = strSQL & "oh_nr,"
strSQL = strSQL & "lager,"
strSQL = strSQL & "minlager,"
strSQL = strSQL & "kat,"
strSQL = strSQL & "tekst,"
strSQL = strSQL & "pris,"
strSQL = strSQL & "vis,"
strSQL = strSQL & "reol)"
strSQL = strSQL & " values( "
strSQL = strSQL & "'" & request.form("oh_nr") & "',"
strSQL = strSQL & request.form("lager") & ","
strSQL = strSQL & request.form("minlager") & ","
strSQL = strSQL & request.form("kat") & ","
strSQL = strSQL & "'" & request.form("tekst") & "',"
strSQL = strSQL & "'" & request.form("pris") & "',"
strSQL = strSQL & strvis & ","
strSQL = strSQL & "'" & request.form("skuffe") & "')"
conn.execute(strSQL)
response.write strSQL
------------------
fejl:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
