adminnewsdel.asp

一套在线考试系统

<!--#include file="conn.asp"-->
<%
Dim i
Dim j
Dim id
Dim newsid
id=request("newsid")
newsid=split(id,",")
i=ubound(newsid)
for j=0 to i
  sql="select * from exam_news where newsid='"& trim(newsid(j))&"'"
  set rs=server.createobject("adodb.recordset")
  rs.open sql,conn,3,2
  if not rs.eof then
  rs.delete
  rs.update
  rs.close
  end if

  sql="select * from waitforpass where objid='"& trim(newsid(j))&"'"
  set rs=server.createobject("adodb.recordset")
  rs.open sql,conn,3,2
  if not rs.eof then
  rs.delete
  rs.update
  rs.close
  end if

next
response.redirect "adminnews.asp"
%>