Multiple pages on recordsets

[matthewralston]

Hello...

I often have an ASP (and now a few PHP) pages that effectively get a recordset and print the entire contents in a table.

Obviously if there are lots of records the table ends up huge and takes longer for the browser to load. I've seen on many sites (these forums, search engines like Yahoo! and Google, etc) that a page will list say 10 or 20 records then have links going to the next, pevious, first & last pages. On Google there is is even a string of numbers allowing you to navigate straight to a specific page.

So...the big question! Can someone show me how to do this please?

I'd like to be able to do it in ASP & PHP.

[Shafee]

If you are using ADO you can do it. Try the AbsolutePage property.

[matthewralston]

Yes, I did have a play around with that and a few other properties like AbsolutePosition, PageSize & PageCount but I couldn't get it to work.

Can someone please show me a quick example please?
Or if you've done it but can't be bothered simplifying the code I don't mind sifting through a working page's code...

[Shafee]

You need to set the CursorLocation property to adUseClient. Then it will work.


Click here for an example from MSDN

[matthewralston]

I'll give it a go...

[Active]

See this Interesting tutorial.
http://www.stardeveloper.com/asp_paging_1.asp