Is there a way I can skip like the first 10 results of a query? I would like to be able to show the first 10 records on one page then display the rest on another page.
Do a search in the Faqs for paging
I don't really want to page. I just want to show 10 records on one page, then show all the rest on another page. Isn't there a way to skip the first 10 records of a query?
Well yes if your database is MySql, but I assume it isn't.<BR><BR>You could use Getrows() to turn the Rs into an array and then pass that to the second page. Or you could just use rs.Movenext to loop through 10 times and then display the rest.