回 帖 发 新 帖 刷新版面

主题:请问一个排序的问题

我在做图片显示的时候,本来是循环显示10张图片,但是只显示了第一张,请问是什么原因,是哪个地方循环语句写错了?麻烦各位指点一下,我也是这里常客了。代码如下:
<table width="699" height="57" border="0" cellpadding="0" cellspacing="0">
                <tr>
                <%set rss=server.CreateObject("adodb.recordset")
            sqls="select top 10 * from market"
            rss.open sqls,conn
            do while not rss.eof
            %>
                  <td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
                <tr>
                  <td height="19"><div align="center"><%=rss("p_name")%></div></td>
                </tr>
                <tr>
                  <td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
                </tr>
              </table></td>
                <%rss.movenext
              if not rss.eof or rss.bof then
              response.Write "<td width='100'> </td>"
              exit do
              end if%>
                  <td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
                <tr>
                  <td height="19"><div align="center"><%=rss("p_name")%></div></td>
                </tr>
                <tr>
                  <td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
                </tr>
              </table></td>
                <%rss.movenext
              if not rss.eof or rss.bof then
              response.Write "<td width='100'> </td>"
              exit do
              end if%>
                  <td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
                <tr>
                  <td height="19"><div align="center"><%=rss("p_name")%></div></td>
                </tr>
                <tr>
                  <td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
                </tr>
              </table></td>
                <%rss.movenext
              if not rss.eof or rss.bof then
              response.Write "<td width='100'> </td>"
              exit do
              end if%>
                  <td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
                <tr>
                  <td height="19"><div align="center"><%=rss("p_name")%></div></td>
                </tr>
                <tr>
                  <td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
                </tr>
              </table></td>
                <%rss.movenext
              if not rss.eof or rss.bof then
              response.Write "<td width='100'> </td>"
              exit do
              end if%>
                  <td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
                <tr>
                  <td height="19"><div align="center"><%=rss("p_name")%></div></td>
                </tr>
                <tr>
                  <td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
                </tr>
              </table></td>
             
                </tr> <%rss.movenext
              loop
              rss.close%>
              </table>

回复列表 (共3个回复)

沙发

if not rss.eof or rss.bof then
              response.Write "<td width='100'> </td>"
              exit do
              end if
这个写的不对吧,这样不是循环一次就跳出循环了吗?

板凳

楼主为什么不循环之前不先做个判断,数据库里面是否有记录呢。。而等循环完了瑞做判断
do while not rss.eof
            %>
                  <td><table width="125" height="110" border="0" align="center" cellpadding="0" cellspacing="0" background="images/bg.jpg">
                <tr>
                  <td height="19"><div align="center"><%=rss("p_name")%></div></td>
                </tr>
                <tr>
                  <td><div align="center"><img src="<%=rss("picurl")%>" width="100" height="80" /></div></td>
                </tr>
              </table></td>
                <%rss.movenext
              if not rss.eof or rss.bof then
              response.Write "<td width='100'> </td>"
              exit do
              end if%>

3 楼

谢谢楼上两位,就是NOT RSS.EOF那里错了

我来回复

您尚未登录,请登录后再回复。点此登录或注册