Ok, im making a news updating panel for my bands site.
i have all of it down, exept the looging in part.
this is waht i have.
[left] <html>
<head>
<%
username = Request.Form("username")
password = Request.Form("password")
Set Conn = Server.CreateObject("ADODB.Connection")
lpath = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("main.mdb")
Conn.Open(lpath)
set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "SELECT username, password, level FROM members WHERE username LIKE" & username & "AND password LIKE " & password & ";", Conn
If Not(RS.EOF) then
Session("username") = RS.fields.item("username")
Session("login") = 1
Session("level") = RS.fields.item("level")
if Session("login") = 1 AND Session("level") >1 then
Response.Redirect("default.asp?s=loggedin")
ELSE
Response.Redirect("default.asp?s=badinfo")
end if
RS.close
set Rs = nothing
end if
Conn.close
set Conn = nothing
%>
</head>
<body>
</body>
</html> [/left]
thats where i point the login from to. All i get is a 500 error. I really dont know whats going on with it.
thanks for any help
