Anyone here know ASP?
If so, Id appreciate help!
Alright, I have a support website for my business but ever since I transfered code, I keep on getting this error.
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/support/details.asp, line 22
thats when I enter support/details.asp?id=747710
Here is like 22 and up of the code.
If so, Id appreciate help!
Alright, I have a support website for my business but ever since I transfered code, I keep on getting this error.
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/support/details.asp, line 22
thats when I enter support/details.asp?id=747710
Here is like 22 and up of the code.
Code:
SQL = "SELECT *"
SQL = SQL & " FROM Info "
SQL = SQL & "Where ID = " &Request.QueryString("ID") & ""
Response.Write(SQL)
' Response.Write("<BR>")
set RS_H = Server.CreateObject("ADODB.Recordset")
Line 22--> RS_H.Open SQL, Conn, adOpenKeyset, adLockOptimistic