<% set rs = server.createobject("adodb.recordset")
rs.open "select * from type",conn,1,1
if err.number <> 0 then
response.write "数据库出错"
else
if rs.bof and rs.eof then
rs.close
response.write "没有类别"
response.end
else
do while not rs.eof
%>
<% set rsc=server.createobject("adodb.recordset")
sql="select * from border where typeid=" & rs("typeid") & " order by borderid"
rsc.open sql,conn,1,1
if err.number <> 0 then
response.write "数据库出错"
else
if not rsc.bof and not rsc.eof then %>
<% set rs = server.createobject("adodb.recordset")
rs.open "select * from type",conn,1,1
if err.number <> 0 then
response.write "数据库出错"
else
if rs.bof and rs.eof then
rs.close
response.write "没有类别"
response.end
else
do while not rs.eof
%>
<% set rsc=server.createobject("adodb.recordset")
sql="select * from border where typeid=" & rs("typeid") & " order by borderid"
rsc.open sql,conn,1,1
if err.number <> 0 then
response.write "数据库出错"
else
if not rsc.bof and not rsc.eof then %>
<% set rs = server.createobject("adodb.recordset")
rs.open "select * from type where typeid=" & cstr(session("purview")),conn,1,1
if err.number <> 0 then
response.write "数据库出错"
else
if rs.bof and rs.eof then
rs.close
response.write "没有类别"
response.end
else
%>
<% set rsc=server.createobject("adodb.recordset")
sql="select * from border where typeid=" & rs("typeid") & " order by borderid"
rsc.open sql,conn,1,1
if err.number <> 0 then
response.write "数据库出错"
else
if not rsc.bof and not rsc.eof then %>