<%
sql="select * from miscell_class where basclass='"+basclass+"' and flag='0' order by sortnum"
rs.open sql,cn,1,1
i=1
do while not rs.EOF
url="sites_web.asp?classcode="+trim(rs("classcode"))
%>| ·<%=trim(rs("classname"))%> |
<%
if i mod 2 = 0 then response.write" "
i=i+1
rs.MoveNext
loop
rs.Close
%>
|
|
|
<%
sqltext="select classcode,classname from miscell_class where basclass='900' and flag='0' order by sortnum "
rs.Open sqltext,cn,1,1
do while not rs.EOF
%>
<%
sql="select keyno,title,website from miscell where classcode='"+rs(0)+"'"
rs2.Open sql,cn,1,1
k=1
do while not rs2.EOF and k<=20
%>
| " class="a01" target=_blank><%=trim(rs2("title"))%> |
<%
if k mod 5 = 0 then response.write" "
k=k+1
rs2.MoveNext
loop
rs2.Close
%>
|
|
<%
rs.MoveNext
loop
rs.Close
%>
|
|