How to slice query results?

Results 1 to 3 of 3

Thread: How to slice query results?

  1. #1
    Big J. Guest

    Default How to slice query results?

    This might seem quite simple for you advanced guys but anyway. I&#039m developing a search engine with Asp & Access and I have a problem with the results which I got from query. I only want to show first 10 results on a first page then 10 on the next and so on. You understand this better if you go to altavista and submit a search. Can I somehow do query for the first 10 results and then continue on the next page? I would really appreciate your help!

  2. #2
    Join Date
    Dec 1969
    Posts
    1,671

    Default RE: How to slice query results?

    Big Guy,<BR><BR>What you are wanting to do is "page" your results.<BR>I think there is a good example over at www.learnasp.com<BR>in the tutorials section but I can&#039t connect to them right now (ARG !) You should check them out anyway.<BR><BR>I&#039m 99% sure there was an example that would let you select the # of records per page and so-on. <BR><BR>The other option is that Visual Interdev has a design time control that will allow you to page recordsets. That is if you have Interdev.<BR><BR><BR>Mike

  3. #3
    Big J. Guest

    Default RE: How to slice query results?

    Thanks, Mike! I pay that tutorial site a visit.

Posting Permissions

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