asp二级目录排序问题

来源：百度知道 编辑：UC知道 时间：2024/05/12 01:12:57
我的第二级目录显示的数据是按表中数据默认的顺序排列的，现在如何使显示出来的数据按名字排列，就是按
A
AA
AB
B
BA
BB
这样的顺序排列，代码太长，发不全，先发第二级目录的显示代码
<%
anclassid=rsanclass("anclassid")
set rsnclass = conn.execute("select * from nclass where anclassid="&cstr(rsanclass("anclassid"))&" order by nclassid")
do while not rsnclass.eof%>
   
<font color="#0000FF">·</font> <A
href="dingdan.asp?anclass=<%=rsanclass("anclass")%>&nclass=<%=rsnclass("nclass")%>" onFocus="this.blur()" OnClick="return openAdminWindow(this.href);" target="_blank"><%=rsnclass("nclass")%>
</A> <BR>
<%rsnclass.movenext
loop
%>

只要把order by nclassid改为order by nclass即可

<%
anclassid=rsanclass("anclassid")
set rsnclass = conn.execute("select * from nclass where anclassid="&cstr(rsanclass("anclassid"))&" order by nclass")
do while not rsnclass.eof%>

<font color="#0000FF">·</font> <A
href="dingdan.asp?anclass=<%=rsanclass("anclass")%>&nclass=<%=rsnclass("nclass")%>" onFocus="this.blur()" OnClick="return openAdminWindow(this.href);" target="_blank"><%=rsnclass("nclass")%>
</A> <BR>
<%rsnclass.movenext
loop
%>
</DIV>
<%rsanclass.movenext
loop
rsanclass.close
%>
<SCRIPT language=JavaScript>
if (NS4) {
firstEl = "KB1Parent";
firstInd = getIndex(firstEl);
arrange();
}
</