<div>
here we go, using the rs.eof property:<br />

<pre><code id="code-31256">&lt;% 
while not rs.eof
%&gt; 
&lt;Table&gt;
&lt;tr&gt;
 &lt;td&gt;&lt;%=rs(&quot;name&quot;)%&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;Table&gt; 
&lt;%  
  rs.MoveNext
wend
%&gt;
</code></pre>
</div>


here we go, using the rs.eof property:


<% 
while not rs.eof
%> 
<Table>
<tr>
 <td><%=rs("name")%></td>
</tr>
<Table> 
<%  
  rs.MoveNext
wend
%>


<div>
Thanks angellll.<br />
But I need the data from 1 to Itemcount only.<br />
I am trying to display the certain data on each page. <br />
Instead of rs.EOF is there anyway that I can bring data that is from 1 to itemcount?<br />
itemcount is rs.pagesize.<br />
<br />
I have rest of the coding but it's too much to post it up. I just need if I can use Do Until...loop query in this situation. <br />
Thank you.
</div>


Thanks angellll.
But I need the data from 1 to Itemcount only.
I am trying to display the certain data on each page.
Instead of rs.EOF is there anyway that I can bring data that is from 1 to itemcount?
itemcount is rs.pagesize.

I have rest of the coding but it's too much to post it up. I just need if I can use Do Until...loop query in this situation.
Thank you.

<div>
<div class="content wysiwyg-content">
I have a query that uses &quot;Next&quot; query. What if I want to use Do Until....Loop query, How do I convert this query to that?<br />
Thank you.<br />
<br />
+++++++++++++++++My coding++++++++++++++++++++<wbr />++++++++++<wbr />++++++++++<wbr />+++<br />
&lt;%<br />
Dim itemcount<br />
Itemcount=rs.pagesize<br />
<br />
For 1 to Itemcount<br />
%&gt;<br />
<br />
&lt;Table&gt;<br />
&lt;tr&gt;<br />
&nbsp;&lt;td&gt;&lt;%=rs(&quot;name&quot;)%&gt;&lt;/td&gt;<br />
&lt;/tr&gt;<br />
&lt;Table&gt;<br />
<br />
&lt;% rs.MoveNext<br />
Next %&gt;
</div>
</div>


I have a query that uses "Next" query. What if I want to use Do Until....Loop query, How do I convert this query to that?
Thank you.

+++++++++++++++++My coding+++++++++++++++++++++++++++++++++++++++++++
<%
Dim itemcount
Itemcount=rs.pagesize

For 1 to Itemcount
%>

<Table>
<tr>
 <td><%=rs("name")%></td>
</tr>
<Table>

<% rs.MoveNext
Next %>

In Classic ASP, How do I convert &quot;Next&quot; query to &quot;Do Until...Loop&quot; query?

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

In Classic ASP, How do I convert &quot;Next&quot; query to &quot;Do Until...Loop&quot; query?

In Classic ASP, How do I convert "Next" query to "Do Until...Loop" query?