set rs_s=server.CreateObject("adodb.recordset")

set rs_s=server.CreateObject("adodb.recordset")
我想在每个大类的后面显示小类,数据库里每种大类都有小分类都有记录,但为什么网页里却总显示:暂无小分类呢?
<%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是排序么?
← 上一篇: 下一篇: →