Hi,
You can do this way ,
On Login.asp page , write this code for checking the If user is Administrator or not.
<%
Dim sql
Dim con
Dim rs
Dim username
set con = server.CreateObject("adodb.Connection")
con.connectionString = "....."
con.open
'''After checking that userName and Password are valid you will check that
if he is administrator
userName = Request.Form("txtUsername")
sql = "Select * from tablename where User = '" & userName & "'
set rs = con.execute(sql)
Dim loginType
If not rs.Eof then
''''''Get its loginType
loginType = rs.Fields("loginType")
If loginType = "Administrator" then
''''''''''''''If user is administrator
Response.Redirect("Admin.asp")
else
'''''''''''''If user is not administrator , redirect to some other page displaying Access Denied
Response.Redirect("default.asp")
end if
end if
rs.close
con.close
%>
i am using the link for administrator page .
i wants to when click on that page login page is display for checking he is administrator or not.
so what code i have to use for that.
241
