If Not rs.EOF Then
counter = 1
Do Until rs.EOF or counter = 5

' Stuff I am looping here

rs.MoveNext
counter = counter + 1
Loop
End If

quote:

---

I have a loop that shows all my records. Now I need to know how to have it
only bring back 5 or 10 records at a time.

---

quote:

---

quote:

---

I have a loop that shows all my records. Now I need to know how to have it
only bring back 5 or 10 records at a time.

---

Depending on your database, another option would be to use "SELECT TOP x" to limit the number of records returned. If your SQL statement would return 100+ records and you know you only need 5 or 10, then your database server doesn't have to do additional work by returning all the records - plus then it's more efficient on the asp side because you don't have to do additional programming to step through and count each record.

---