我想通过不同的权限进到不同的界面 powerlevel 是userinfo里面的权限6 是管理员
<%
session("loginid")=request.form("loginid")'得到输入帐号
session("password")=request.form("password")'得到输入密码
set conn=server.createobject("adodb.connection")
conn.open "provider=sqloledb;data source=(local); initial catalog='AspData'; user id='sa';password=''"
sql="select * from userinfo where loginid='"&session("loginid")&"'and password='"&session("password")&"'"
set user=conn.execute(sql)
if not user.eof then
if rs("powerlevel")=6 then
response.redirect "houtai.asp"
else
response.redirect "chakan.asp"
end if
else
%>
<script language=javascript>
if ( confirm("用户名与密码不正确,请从新输入!"))
</script>
<% end if %>
<script language="javascript">
setTimeout("location.replace('index.asp')",20)
</script>