Do while loop

Results 1 to 3 of 3

Thread: Do while loop

  1. #1
    LittlePaul Guest

    Default Do while loop

    Hi have this:<BR> Do while Not oRSa.EOF<BR> Response.Write "record"<BR> oRSa.MoveNext<BR> Loop<BR>and it, and none of the other recersive methods i use (eg for..., or do until...) will wrk either. what am i doing wrong. all code works apart from the reccersion.<BR><BR>Error returned is:<BR>Error Type:<BR>ADODB.Field (0x80020009)<BR>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.<BR><BR>any ideas? cheers, lp

  2. #2
    Join Date
    Dec 1969

    Default RE: Do while loop

    Just before starting the Do..While do this:<BR>If not oRSa.eof then<BR>do while not<BR>.<BR>.<BR>.<BR>loop<BR>else<BR>response.wri te "No records"<BR>end if<BR>

  3. #3
    LittlePaul Guest

    Default RE: Do while loop

    nope, still wont work. have spent several hours on it now. theres something wrong with the rs.EOF in the access database thing. i dont know what it is, but the reccersion now works when i use (eof-1).<BR><BR>anyone had any problems like this?<BR><BR>cheers, lp

Posting Permissions

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