Results 1 to 2 of 2

Thread: If next record is Rs.eof

  1. #1
    Join Date
    Apr 2003
    Location
    Portugal
    Posts
    2

    Question If next record is Rs.eof

    How can I detect if the next record on recordset is the last one of it?

    I have this code:

    For x=1 To Rs.PageSize
    'Here, i need to check the last record
    'something like this:

    If Rs.Next = Rs.Eof then
    response.write "one"
    else
    response.write "two"
    End if

    '#####
    Rs.MoveNext
    If Rs.Eof Then
    Exit For
    End If
    Next

    Is this possible to do? How??

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    You are in the wrong forum. Try the ASP forum instead for ASP related posting. Product Asp-db detects that automatically.

    FK

Posting Permissions

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