E
Eugene Anthony
asp code:
set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/db/upload/stelladb.mdb") & ";"
set rs = Server.CreateObject("ADODB.Recordset")
conn.qGetUser p1,p2,rs
if rs(0) = "Administrator" OR rs(0) = "User" then
session("boolean") = "true"
End if
if Err.number <> 0 then
Response.Write(Err.number & ":" & Err.Description & "<br>")end if
on Error goto 0
conn.close
Set conn = nothing
ms access sql:
SELECT Type FROM Account WHERE username=[p1] AND password=[p2];
The problem that I am facing is that if I enter and invalid username or
password what happens is I get the following error:
"-2147352567:Either BOF or EOF is True, or the current record has been
deleted. Requested operation requires a current record"
How do I solve the problem?.
Eugene Anthony
set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/db/upload/stelladb.mdb") & ";"
set rs = Server.CreateObject("ADODB.Recordset")
conn.qGetUser p1,p2,rs
if rs(0) = "Administrator" OR rs(0) = "User" then
session("boolean") = "true"
End if
if Err.number <> 0 then
Response.Write(Err.number & ":" & Err.Description & "<br>")end if
on Error goto 0
conn.close
Set conn = nothing
ms access sql:
SELECT Type FROM Account WHERE username=[p1] AND password=[p2];
The problem that I am facing is that if I enter and invalid username or
password what happens is I get the following error:
"-2147352567:Either BOF or EOF is True, or the current record has been
deleted. Requested operation requires a current record"
How do I solve the problem?.
Eugene Anthony