Recordset er tomt????
<%txtusername = Request.Form(\"txtusername\")
txtpassword = Request.Form(\"txtpassword\")
\'Opprette connection objekt
Set oConn = Server.CreateObject(\"ADODB.Connection\")
\' Logge inn i databasen
oConn.Open \"Driver={Microsoft Access Driver (*.mdb)};dbq=\" & Server.MapPath(\"database/userlevel.mdb\")
SQL = \"SELECT User,Password,SecurityLevel FROM Users WHERE User =\'\" & txtusername & \"\' AND Password=\'\" & txtpassword & \"\'\"
Set oRS = oConn.Execute(SQL)
If oRS(\"SecurityLevel\") = 0 Then
Response.Write \"Du har ikke tilgang\"
ElseIf oRS(\"SecurityLevel\") = 1 Then
Response.Write \"Du hadde userlevel 1\"
ElseIf oRS(\"SecurityLevel\") = 2 Then
Response.Write \"Du hadde userlevel 2\"
ElseIf oRS(\"SecurityLevel\") = 3 Then
Response.Write \"Du hadde userlevel 3\"
End If
\' Lukke connection objekt
oConn.Close
\' Frigi minnet
Set oConn = Nothing
%>
Hva skal jeg skrive hvis brukeren finnes elle recordsetet er tomt så brukeren får en feilmelding?
