syntaksfejl i INSERT INTO-sætningen
Hvorfor får jeg den fejl? Hvad er der galt her?-----------------------------------------------
<%
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("produkter.mdb")
Conn.Open DSN
strSQL = "INSERT INTO roedvine ("
strSQL = strSQL & "varenr, "
strSQL = strSQL & "navn, "
strSQL = strSQL & "aargang, "
strSQL = strSQL & "nationalitet, "
strSQL = strSQL & "distrikt, "
strSQL = strSQL & "beskrivelse, "
strSQL = strSQL & "pris, "
strSQL = strSQL & "billede) "
strSQL = strSQL & "values( "
strSQL = strSQL & " " & Server.HTMLEncode(Request("f_varenr")) & ", "
strSQL = strSQL & " " & Server.HTMLEncode(Request("f_navn")) & ", "
strSQL = strSQL & " " & Server.HTMLEncode(Request("f_aargang")) & ", "
strSQL = strSQL & " " & Server.HTMLEncode(Request("f_nationalitet")) & ", "
strSQL = strSQL & " " & Server.HTMLEncode(Request("f_distrikt")) & ", "
strSQL = strSQL & " " & Server.HTMLEncode(Request("t_beskrivelse")) & ", "
strSQL = strSQL & " " & Server.HTMLEncode(Request("f_pris")) & ", "
strSQL = strSQL & " " & Server.HTMLEncode(Request("f_billede")) & ") "
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
%>
Databasen er opdateret.
-----------------------------------------------
Der er en syntaksfejl i INSERT INTO-sætningen.
/go.asp, line 38
linie 38 --> Conn.Execute(strSQL)
