Data type mismatch in criteria expression.
For denne fejl plutselig ?Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/match/admin/GemProfil.asp, line 76
den ser således ud:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("xxxx.mdb")
SQL= "INSERT INTO match (matchnavn, dato, gruppea, no1a, navn1a, point1a, no2a, navn2a, point2a, no3a, navn3a, point3a, no4a, navn4a, point4a, no5a, navn5a, point5a, gruppeb, no1b, navn1b, point1b, no2b, navn2b, point2b, no3b, navn3b, point3b, no4b, navn4b, point4b, no5b, navn5b, point5b, gruppec, no1c, navn1c, point1c, no2c, navn2c, point2c, no3c, navn3c, point3c, no4c, navn4c, point4c, no5c, navn5c, point5c, matchleder, info, sponsorimg)"
SQL = SQL & " VALUES ('" & request.form("matchnavn") & "','" & request.form("dato") & "','" & request.form("gruppea") & "','" & request.form("no1a") & "','" & request.form("navn1a") & "','" & request.form("point1a") & "','" & request.form("no2a") & "','" & request.form("navn2a") & "','" & request.form("point2a") & "','" & request.form("no3a") & "','" & request.form("navn3a") & "','" & request.form("point3a") & "','" & request.form("no4a") & "','" & request.form("navn4a") & "','" & request.form("point4a") & "','" & request.form("no5a") & "','" & request.form("navn5a") & "','" & request.form("point5a") & "','" & request.form("gruppeb") & "','" & request.form("no1b") & "','" & request.form("navn1b") & "','" & request.form("point1b") & "','" & request.form("no2b") & "','" & request.form("navn2b") & "','" & request.form("point2b") & "','" & request.form("no3b") & "','" & request.form("navn3b") & "','" & request.form("point3b") & "','" & request.form("no4b") & "','" & request.form("navn4b") & "','" & request.form("point4b") & "','" & request.form("no5b") & "','" & request.form("navn5b") & "','" & request.form("point5b") & "','" & request.form("gruppec") & "','" & request.form("no1c") & "','" & request.form("navn1c") & "','" & request.form("point1c") & "','" & request.form("no2c") & "','" & request.form("navn2c") & "','" & request.form("point2c") & "','" & request.form("no3c") & "','" & request.form("navn3c") & "','" & request.form("point3c") & "','" & request.form("no4c") & "','" & request.form("navn4c") & "','" & request.form("point4c") & "','" & request.form("no5c") & "','" & request.form("navn5c") & "','" & request.form("point5c") & "','" & request.form("matchleder") & "','" & request.form("info") & "','" & request.form("sponsorimg") & "')"
Conn.Execute (SQL)