
<%set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from ssort where anclassid="&rs("anclassid")&" order by nclassidorder",conn,1,1
if rs_s.recordcount=0 then %>
<%else
i=0
while not rs_s.eof
%>
&nid=<%=rs_s("nclassid")%>"><%=rs_s("nclass")%><%rs_s.movenext
if rs_s.eof then
response.write " "
else
%>
&nid=<%=rs_s("nclassid")%>"><%=rs_s("nclass")%><%rs_s.movenext
if rs_s.eof then
response.write " "
else
%>
&nid=<%=rs_s("nclassid")%>"><%=rs_s("nclass")%><%rs_s.movenext
if rs_s.eof then
response.write " "
else
%>
&nid=<%=rs_s("nclassid")%>"><%=rs_s("nclass")%><%rs_s.movenext
if rs_s.eof then
response.write " "
else
%>
&nid=<%=rs_s("nclassid")%>"><%=rs_s("nclass")%> <%
rs_s.movenext
end if
end if
end if
end if
wend
end if
end if
end if
%>
代键咐码太困让乱,
需要用ASP嵌套查询
while rs()
while rs_1()
while rs_2()
wend
wend
wend
总之要汪亮局用不同的RS记录集才行
while rs()
while rs_1()
while rs_2()
wend
wend
wend
order by nclassidorder是排序么?