boardset.asp

ASP+SQL2000+

<!--#include file="conn.asp"-->
<%IF request.cookies("KEY")<>"super" THEN
response.redirect "index_face.asp"
response.end
END IF%>
<%
inuse=request.form("inuse")
if inuse="" then
response.write "<script>alert('对不起，请您选择公告项！');history.go(-1);</Script>"
	
	Response.End 
	
end if
set rs=server.createobject("adodb.recordset")
sql="Select inuse from board where inuse=1"
rs.open sql,conn,1,3
if not rs.eof then
	do while not rs.eof
		rs("inuse")=0
	rs.movenext
	loop
end if
rs.close

sql="Select inuse from board where ID="&inuse
rs.open sql,conn,1,3
if not rs.EOF then
	do while not rs.EOF 
		rs("inuse")=1
	rs.MoveNext 
	loop
end if
rs.close
set rs=nothing
dim title
set rs=server.createobject("adodb.recordset")
sql="select * from board where inuse=1"
rs.open sql,conn,1,1
title=rs("title")
rs.close
set rs=nothing

conn.close
set conn=nothing
response.redirect "boardManage.asp"
%>