怎么设置删除权限的问题
<%
if Session("adminid")="admin" then '我在数据库建了个authority(权限)字段,数据类型是数字,想通过0和1判断是否可以执行删除权限
if request("id")<>"" then
set rs=conn.execute("delete from light where id="&request("id"))
response.write "<script language='javascript'>"
response.write "alert('删除成功!');"
response.write "window.location.href='importlist.asp';"
response.write "</script>"
else
conn.execute "delete from light where id in("&request("chkOne")&")"
response.write "<script language='javascript'>"
response.write "alert('删除成功!');"
response.write "window.location.href='importlist.asp';"
response.write "</script>"
end if
else
response.write "<script language='javascript'>"
response.write "alert('对不起,您没有权限删除记录!');"
response.write "window.location.href='importlist.asp';"
response.write "</script>"
end if
%>
求大神解答,第一行的注释里提了问题
[解决办法]
if Session("adminid")="admin" and 这里加上条件就可以了啊 then '我在数据库建了个authority(权限)字段,数据类型是数字,想通过0和1判断是否可以执行删除权限
if request("id")<>"" then
set rs=conn.execute("delete from light where id="&request("id"))
response.write "<script language='javascript'>"
response.write "alert('删除成功!');"
response.write "window.location.href='importlist.asp';"
response.write "</script>"
else
conn.execute "delete from light where id in("&request("chkOne")&")"
response.write "<script language='javascript'>"
response.write "alert('删除成功!');"
response.write "window.location.href='importlist.asp';"
response.write "</script>"
end if
else
response.write "<script language='javascript'>"
response.write "alert('对不起,您没有权限删除记录!');"
response.write "window.location.href='importlist.asp';"
response.write "</script>"
end if
[解决办法]
你都知道用0/1来标识了,思路就出来了啊~通过用户名读出他的权限是0还是1,然后根据0/1来决定相关的代码是不是执行就好了