Home > front end >  About the same recordset, with multiple loop output page
About the same recordset, with multiple loop output page

Time:02-07

<%
Set the rs=server. Createobject (" adodb. You ")
SQL="SELECT * FROM table ORDER BY ORDER desc"
Rs. The Open SQL, conn, 1, 1
% & gt;
With page position 1
<%
Eof
the do while not rs.% & gt;
<%=rs (" fields ") % & gt;
<%
Rs. Movenext
Loop
% & gt;
Position with page 2
<%
Eof
the do while not rs.% & gt;
<%=rs (" fields ") % & gt;
<%
Rs. Movenext
Loop
% & gt;
<%
Rs. The close ()
Set the rs=nothing
Conn. Close ()
Set the conn=nothing
% & gt;

The above code at position 1 page can normal circulation output, why with position 1 page output is empty, ace to give directions, how to change, thank you
  •  Tags:  
  • ASP
  • Related