Insert into fejl, a kan ikk finde ud hvorfor
Jeg forsøger at sætte data ind i min DB men får fejl:Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/daek/add_tire.asp, line 24
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
POST 209 bytes to /daek/add_tire.asp
POST Data:
tabel_brand=BRIDGESTONE&tabel_model=dfg&tabel_size_1=dfg&tabel_size_2=sdfg&tabel_size_3=sdfg&tabel_rfelt=R&tabel_speed=J&tabel_li=sdfg&tabel_tfelt=TT&tabel_europrize=sdfg&tabel_dkprize=sdfg&Submit=Upl . . .
Kode:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("daek.mdb")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
' SQL sætning opbygges
strSQL = "INSERT INTO daek_tabel "
strSQL = strSQL & "(brand, model, size_1, size_2, size_3, rfelt, speed, li, t_felt, euro_prize, dk_prize) values ("
strSQL = strSQL & "'" & request.form("tabel_brand") & "',"
strSQL = strSQL & "'" & request.form("tabel_model") & "',"
strSQL = strSQL & "'" & request.form("tabel_size_1") & "',"
strSQL = strSQL & "'" & request.form("tabel_size_2") & "',"
strSQL = strSQL & "'" & request.form("tabel_size_3") & "',"
strSQL = strSQL & "'" & request.form("tabel_rfelt") & "',"
strSQL = strSQL & "'" & request.form("tabel_speed") & "',"
strSQL = strSQL & "'" & request.form("tabel_li") & "',"
strSQL = strSQL & "'" & Request.form("tabel_tfelt") & "'"
strSQL = strSQL & "'" & request.form("tabel_europrize") & "',"
strSQL = strSQL & "'" & request.form("tabel_dkprize") & "',"
strSQL = strSQL & ")"
Conn.execute(strSQL)
'Response.write Request.Form("brand")
%>
