Problem haster!!!!!!
Her er koden:<%
Option Explicit
Response.Buffer = "True"
Dim objConn
Dim SQL
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("bestilling.mdb") & ";"
SQL = "Insert into kunder(navn, firma, adresse, dato, by, postnr, e-mail, telefonnr, kommentar) "
SQL = SQL & "Values('" & Request.Form("navn") & "',"
SQL = SQL & "'" & Request.Form("firma") & "',"
SQL = SQL & "'" & Request.Form("adresse") & "',"
SQL = SQL & "'" & Date() + Time() & "',"
SQL = SQL & "'" & Request.Form("by") & "',"
SQL = SQL & "'" & Request.Form("postnr") & "',"
SQL = SQL & "'" & Request.Form("e-mail") & "',"
SQL = SQL & "'" & Request.Form("telefonnr") & "',"
SQL = SQL & "'" & Replace(Request.Form("kommentar"),"'", "''") & "',"
SQL = SQL & "'" & Request.ServerVariables("REMOTE_HOST") & "',"
if Request.Form("site1") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site1") & ","
end if
if Request.Form("site2") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site2") & ","
end if
if Request.Form("site3") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site3") & ","
end if
if Request.Form("site4") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site4") & ","
end if
if Request.Form("site5") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site5") & ","
end if
if Request.Form("site6") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site6") & ","
end if
if Request.Form("site7") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site7") & ","
end if
if Request.Form("site8") = "" Then
SQL = SQL & "0,"
else
SQL = SQL & Request.Form("site8") & ","
end if
Response.Write SQL
objConn.Execute (SQL)
objConn.Close
Set objConn = nothing
Response.Redirect ("Tak.asp")
%>
Og her er fejlen:
Insert into kunder(navn, firma, adresse, dato, by, postnr, e-mail, telefonnr, kommentar) Values('a','b','c','17-06-00 16:27:12','d','e','f','g','h','213.237.22.184',V1,0,0,0,0,0,0,0,
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
