select top 5 * from content order by infotime desc


以上的语句不是按照时间来排序最新五条数据的吗？
怎么我显示出7条数据。好奇怪哦。。

求高手帮助

do while ... loop循环?

代码如上：


<%    
                dim sqlBL,rsBL
                sqlbl="select top 5 * from content order by infotime desc"
                set rsbl=server.CreateObject("adodb.recordset")
                rsbl.open sqlbl,conn,1,3
            %>
            <TABLE cellSpacing=0 cellPadding=3 width="99%" align=center border=0>
              <TBODY>
              
                <tr><td height="5"></td></tr>
                <%
                    if not rsbl.eof then
                    do while not rsbl.eof
                %>
                  <TR>
                <TD width="29%"><SPAN  class=red2>[ <%=rsbl("BigClassName")%> ]</SPAN></TD>
                <TD width="70%">
                    <A href="blog/blog_list.asp?id=<%=rsbl("id")%>"><%=left(rsbl("title"),14)%>...</A>
                </TD>
                 </TR>
                <%
                    rsbl.movenext
                    loop
                    rsbl.close
                    set rsbl=nothing
                    end if                    
                %>

用for循环看看?
for i = 1 to rs.recordcount
if rs.eof then exit for
  ...
rs.movenext
next

还是显示七条啊

Response.Write rs.recordcount
看看一共是多少条记录啊
这种简单的测试要学着做的

<%   
                dim sqlBL,rsBL
                sqlbl="select top 5 * from content order by infotime desc"
                set rsbl=server.CreateObject("adodb.recordset")
                rsbl.open sqlbl,conn,1,3
            %>
            <TABLE cellSpacing=0 cellPadding=3 width="99%" align=center border=0>
              <TBODY>
              
                <tr><td height="5"></td></tr>
                <%
                    if rsbl.eof then
                         Response.write("没有记录")
                    else
                    do while not rsbl.eof
                %>
                  <TR>
                <TD width="29%"><SPAN  class=red2>[ <%=rsbl("BigClassName")%> ]</SPAN></TD>
                <TD width="70%">
                    <A href="blog/blog_list.asp?id=<%=rsbl("id")%>"><%=left(rsbl("title"),14)%>...</A>
                </TD>
                 </TR>
                <%
                    rsbl.movenext
                    loop
                    rsbl.close
                    set rsbl=nothing
                    end if                    
                %>

只读不需要rsbl.open sqlbl,conn,1,3  rsbl.open sqlbl,conn,1,1就可以了
Response.Write sqlbl
Response.End()
输出的SQLBL结果放入数据库查询分析一下

Response.Write ("abc::::::::::::::"+rsbl.recordcount)
    response.End()


什么都没有显示啊

Response.Write sqlbl
Response.End()
输出的SQLBL结果放入数据库查询分析一下