loop qs

Results 1 to 3 of 3

Thread: loop qs

  1. #1
    Join Date
    Dec 1969

    Default loop qs

    Hi,<BR><BR>Thru a query I am getting a recordset with some records. I want to display only specific no. of records(depends on the input var).The code is something like:<BR><BR>while not rs1.EOF <BR>if i&#060;=j then<BR><BR>else<BR><BR>end if<BR>wend<BR><BR>my problem is after i and j are equal I want to get out of the loop. I tried using rs1.movelast after else but sometimes it takes a lot of time. Is there something in asp which I can use so that the control goes after wend statement<BR><BR>Thanks<BR>Archna

  2. #2
    Eddie Campbell Guest

    Default RE: loop qs

    Try<BR>while i&#060;j and not rs.eof<BR>wend

  3. #3
    Join Date
    Dec 1969

    Default RE: loop qs

    use<BR><BR>Do while not rs.eof<BR>if x&#060;=y then<BR>Exit Do<BR>else<BR>....<BR>end if<BR>loop<BR>

Posting Permissions

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