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"  >&nbsp;</td>
                                          <td width="169" height="27" align="left" bgcolor="#FFFFFF"  ><img src="index_files/dot_email.gif" width="5" height="5" />&nbsp;<a href="<%=rs("file_path")%>" target="_blank" class="prodcut" title="<%=rs("title")%>"><%=rs("title")%></a>&nbsp;&nbsp;
            <% 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"  >&nbsp;</td>
                                        </tr>
                                        <%
     rs.movenext
     loop%>
                                        <tr >
                                          <td colspan="3" align="right" bgcolor="#FFFFFF" ><a href="note.asp教程" class="page" >更多資訊...</a>&nbsp;&nbsp;&nbsp;</td>
                                        </tr>
                                        <%
     else
     %>
                                        <tr  class="button3">
                                          <td colspan="3" bgcolor="#FFFFFF">暫時沒有通知通告</td>
                                        </tr>
                                        <%
     end if
     call closedb()
     %>

本站原創轉載註明 www.111cn.net/asp/asper.html