Så här ser felmeddelandet ut:Felmeddelande, men varför? (Löst)
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/medlemssidor/member.asp, line 29
Så här ser koden ut:
<code>
Dim objCon
Dim strRS
Dim strSQL
Dim strPath
Dim iMemberID
Dim strUserName
imemberID = Request.Cookies("Medlem")("memberID")
strUserName = Request.Cookies("Medlem")("username")
If Request.Cookies("Medlem") = "" then
Response.redirect "login.asp"
Else
Response.write "Test"
end if
Set objCon = Server.CreateObject("ADODB.Connection")
strPath = Server.MapPath("../../dbq/medlem.mdb")
objCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath
Set strRS=Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * from members WHERE memberID='" & iMemberID & "'"
strRS.Open strSQL, objCon, 1, 2
</code>
Rad 29 är den sista - strRS.Open strSQL, objCon, 1, 2