asp 指定读取前几条记录

     <%dim sqlnote2
     sqlnote2="select top 8 * from note1 order by id desc"
     call opendb()
     rs.open sqlnote2,conn,1,1
     if not rs.eof then
     do while not rs.eof

     %>
                                        <tr>
                                          <td width="5" height="22" align="left" bgcolor="#FFFFFF" > </td>
                                          <td width="169" height="27" align="left" bgcolor="#FFFFFF" ><img src="index_files/dot_email.gif" width="5" height="5" /> <a href="<%=rs("file_path")%>" target="_blank" class="prodcut" title="<%=rs("title")%>"><%=rs("title")%></a>
            <% if rs("send_date")=date() then
             response.write("<img src=index_files/new1.gif />")
             else response.write(rs("send_date"))
             end if%></td>
                                          <td width="1" height="5" align="left" bgcolor="#FFFFFF" > </td>
                                        </tr>
                                        <%
     rs.movenext
     loop%>
                                        <tr >
                                          <td colspan="3" align="right" bgcolor="#FFFFFF" ><a href="note.asp教程" class="page" >更多信息...</a>   </td>
                                        </tr>
                                        <%
     else
     %>
                                        <tr class="button3">
                                          <td colspan="3" bgcolor="#FFFFFF">暂时没有通知通告</td>
                                        </tr>
                                        <%
     end if
     call closedb()
     %>

本站原创转载注明 www.zzzyk.com/asp/asper.html

补充：asp教程,ASP入门