Fejl

Hvorfor give dette en fejl:

<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"data.mdb\")

SQLstmt = \"UPDATE DISTINCTROW artikel SET dag = \'\" & request.form(\"dag\") & \"\' WHERE VISMD=\" & request.form(\"vismd\")
\'SQLstmt = SQLstmt & \"VALUES (\'\" & request.form(\"dag\") & \"\')\"

response.write sqlstmt

Conn.Execute (SQLstmt)

conn.Close
Set conn = nothing
Set SQLstmt = nothing

Response.Redirect(\"presse-or.asp?mode=eredit\")

end if %>

FEJL:

UPDATE DISTINCTROW artikel SET dag = \'26\' WHERE VISMD=9
Microsoft OLE DB Provider for ODBC Drivers error \'80040e07\'

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/artikeladd2.asp, line 203