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
     
     %>
                                       
                                           
                                           " target="_blank" class="prodcut" title="<%=rs("title")%>"><%=rs("title")%>  
            <% if rs("send_date")=date() then
             response.write("")
             else response.write(rs("send_date"))
             end if%>
                                           
                                       
                                        <%
     rs.movenext
     loop%>
                                       
                                          asp教程" class="page" >更多信息...   
                                       
                                        <%
     else
     %>
                                       
                                          暂时没有通知通告
                                       
                                        <%
     end if
     call closedb()
     %>

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