Paged Recordsets

[codejunkie]

hello all
I'd like to have my table showing only 10 records and listing the number of pages at the bottom using links. As in 1 links to the first page, 2 to the second etc.

I"ve used the usual loop using
while rst.eof = false but I cant' seem to limit the number of pages being viewed it just lists all the records.I've tried using the pageSize() but all i get i errors.
I'd be very gratefull if anyone could help me on this.

codejunkie [sig][/sig]

 

[khorjak]

Read this article:

http://www.programmersresource.com/articles/paging.asp

It shows you exactly what you need.

 

[codejunkie]

thanks khorjak,
the site really helped me.
[sig][/sig]