apply loop to one recordset element only

Set the record to an array
arrayName = RecordSetName.GetRows
and you can loop without worrying about EOF or BOF.
The array is a 2 dimensional array. The first dimension is the numerical position of the field starting with 0. The secod dimension is the row number from the recordset (starting with 0).

If you used the following SQL statement:
select field1, field2 from table
and placed it into the array, arrArray then the first to return field1 from the first row would be <%=arrArray(0,0)%>
field2 from the first row is: <%=arrArray(1,0)%>
field2 from the 30th row is: <%=arrArray(0,29)%>

To loop through the array use:
<%
for i = 0 to Ubound(arrArray,2)
' Write the first field for each row i
   Response.write arrArray(0,i) &"<br>"
next
%>