Retrieving Recordsets N through N + 5

Results 1 to 2 of 2

Thread: Retrieving Recordsets N through N + 5

  1. #1
    Ben Seigel Guest

    Default Retrieving Recordsets N through N + 5

    Hi. I&#039m working on a script that will return five recordsets per page, from based on variables passed through the querystring.<BR><BR>I need either a SELECT statement that grabs records N through N + 5, or a way to disregard the first X recordsets retrieved. <BR><BR>Here is my code:<BR><BR>------------------------------<BR><BR>sql = "select * from "&Category&""<BR><BR> rs.Open sql, cn<BR> while not rs.eof and checker &#060;&#062; "done"<BR> intcounter = intcounter + 1<BR> response.write "intcounter is:&nbsp;" & intcounter & "&nbsp;&nbsp;&nbsp;"<BR> if intcounter mod 5 = 0 then checker = "done"<BR><BR> Response.Write "THE DATA IS :&nbsp;" & rs("field1") &"<BR>"<BR> rs.MoveNext<BR><BR> wend<BR>rs.close<BR>-----------------------------<BR><BR>Please advise, I would appreciate an email notifying me of a response. Many thanks,<BR><BR>Ben<BR><BR><BR>

  2. #2
    Rob Guest

    Default RE: Retrieving Recordsets N through N + 5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts