Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Jun 2002
    Location
    Gulf
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Start printing from the second result ?

    Hi everybody,
    Here's my problem:

    Suppose i have list box that will carry only 10 rows, and i made a search but my result brought up 13 rows. So what i want to do now is to show the latest 10 rows which mean the list box will start from 3 till 13 so it'll be exactly 10 rows in that list box.

    That's my problem and i want to know how to get my records from a database that will start from the third row.

    Some other idea is to start from the bottom to the top, but again i don't know how to do it , So please can u help in this
    =======================
    =======================
    WebMaster
    =======================
    =======================

  • #2
    Regular Coder
    Join Date
    Jun 2002
    Location
    Cincinnati, OH
    Posts
    545
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can use the GetRows() or GetString() method to store your rs into a 2d array or a string(you can split this string to create an array). Whatever method you choose when you loop through

    iLastTenRec = UBound(myRsArray) - 10

    For x = iLastTenRec to UBound(myRsArray)
    fill list box here.
    Next

    The syntax may not be 100% but I hope you get what I am talking about. If you need some more code let me know.

    Links:
    http://www.devguru.com/Technologies/...t_getrows.html

  • #3
    New Coder
    Join Date
    Jun 2002
    Location
    Gulf
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you very much for that great help, it's actually a very good and simple way to do it. Thank you again
    =======================
    =======================
    WebMaster
    =======================
    =======================


  •  

    Posting Permissions

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