admin_classstart.asp

庐江二中

<!--#include file="session.asp"-->
<%checkAdmin2%>
<!--#include file="conn.asp"-->
<%
TheClass=Request("WhatClass")
sql="select * from "&TheClass&" order by ID"
rs.open sql,conn,3,3
i=0
do while not rs.eof
i=i+1
if TheClass="BigClass" then rs("BigClassID")=i
if TheClass="SmallClass" then rs("SmallClassID")=i
if TheClass="Special" then rs("SpecialID")=i
rs.update
rs.movenext
loop
rs.close
set rs=nothing

conn.close
set conn=nothing

response.redirect "admin_"&TheClass&"Mana.asp"
%>