I'm building a small search engine.. I wish to have a part 1 and a part 2 alternate between each other, my only problem is that i need to make sure that i'm not at recordset.EOF within mid loop. Sample Code:

<%
   While NOT rs.eof
%>
PT1
<%
   If NOT rs.eof then
   rs.movenext
Else
   (end loop)
end if
%>
PT2
<% Wend %>
  

Ok, well why dont you use a switch variable:

Dim blnAtFirstStage
blnAtFirstStage = False

Do until rsCommon.eof
  If blnAtFirstStage = False then
    blnAtFirstStage = True
    'Do your stage one stuff
  Else
    blnAtFirstStage = False
    'Do your stage two stuff
  End if
rsCommon.movenext
Loop
rsCommon.close

<%
   While NOT rs.eof
%>
PT1
<%
   If NOT rs.eof then
   rs.movenext
Else
   (end loop)
end if
%>
PT2
<% Wend %>

besides the fact that you totally needlessly say "If NOT rs.EOF" while inside the loop that flat out says already "i am not at the end of the recordset".. making asking "am i at the end" a waste of CPU cycles :-)

While..Wend is kinda old school and more code than is needed...

Guillian suggested a good way, and then a new option opens up for you, "Exit Do" if you need to must out early.....

Here's more on the "Exit" statement of VBScript:
http://www.netzone.ch/caspdoc/html/vbscript_exit_statement.htm - http://www.netzone.ch/caspdoc/html/vbscript_exit_statement.h tm