(0x80040E14) Syntax error in INSERT INTO statement.
hejsaJeg leger med noget ADO & VB kode hvor jeg hele tiden får følgende fejl:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/lotto/DKL_add.asp, line 31
Hvad gør jeg galt???
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:/Inetpub/wwwroot/Lotto/lotto.mdb"
sql="insert into DKLLotto(Day,Month,Year)"
sql=sql & " values "
sql=sql & "('" & Request.Form("Day") & "',"
sql=sql & "'" & Request.Form("Month") & "',"
sql=sql & "'" & Request.Form("Year") & "')"
'on error resume next
conn.Execute sql,recaffected
if err<>0 then
Response.Write("No update permissions!")
else
Response.Write("<h3>" & recaffected & " record added</h3>")
end if
response.write sql
conn.Close
%>
</body>
