Data type mismatch in criteria expression.
Jeg får følgende fejl:Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
Her er min kode:
<%
Set Con = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")
Con.Open "DBQ=" & Server.Mappath("../../db/Booking.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};Password=1234;"
SQL = "SELECT initialer FROM booking WHERE id = '" & Request.Form("id") & "'"
set rs = con.execute (SQL)
if NOT rs.EOF then
if Session("auth_Initial") = rs("initial") OR Session("auth_Gruppenavn") = "Admin" then
sql = "DELETE * From booking Where id = '" & Request.Form("id") & "'"
Con.Execute(Sql)
response.write "Din booking er nu slettet"
else
response.write "Du har ikke har adgang til at slette denne booking da det ikke er dig der har oprettet den."
end if
else
response.write "Denne booking findes ikke"
end if
con.close
%>
