typekillok.asp

ASP+SQL2000+

<!--#include file="Conn.ASP"--><!--#include file=../include/config.asp--><!--#include file="chkuser.asp" -->

<%
IF request.cookies("KEY")<>"super" THEN
response.redirect "index_face.asp"
response.end
END IF

typeID = Request("typeID")
dim typename
set rs=server.createobject("adodb.recordset")
sql="select * from type where typeID="&typeID
rs.open sql,conn,3,3
typename=rs("typename")
rs.close
set rs=nothing

button_value=trim(Request.Form("alert_button"))
if button_value="是" then
conn.execute("delete from news where typeID=" &typeID)
conn.execute("delete from smallclass where typeID=" &typeID)
conn.execute("delete from bigclass where typeID=" &typeID)
conn.execute("delete from type where typeID=" &typeID)
conn.close
set conn=nothing
response.write "<p align=center><font color=red>恭喜您!您选择的总栏已经被删除!<br>"&freetime&"秒钟后返回上页!</font>"
else
response.write "<p align=center><font color=red>您没有执行删除操作!<br>"&freetime&"秒钟后返回上页!</font>"
end if
response.write "<meta http-equiv=""refresh"" content="""&freetime&";url=typemanage.asp"">"
%>