Can someone help me. My error is :
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/add.asp, line 73
my codes are
Expand|Select|Wrap|Line Numbers
- <% dim DataCon, rsRec, strSql, strSql2, rsRec2
- set DataCon = server.createobject("ADODB.Connection")
- DataCon.ConnectionTimeout = 10
- DataCon.CommandTimeout = 30
- DataCon.Open "DBQ=" & Server.mapPath("booking.mdb") & "; Driver={Microsoft Access Driver (*.mdb)}; "
- Set rsRec = server.createobject("ADODB.recordset")
- rsRec.CursorType = 3
- strSql = "SELECT fldDescription FROM tblTimeSlot WHERE fldSlotID =" & request.querystring("slot")
- rsRec.Open strSql, DataCon%>