读书人

如何设置删除权限的有关问题

发布时间: 2013-08-26 12:17:40 作者: rapoo

怎么设置删除权限的问题

<%
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来决定相关的代码是不是执行就好了

读书人网 >ASP

热点推荐