Ron,
Understood, but Rose handles those sorts of things. And I use Postgres,
but other users of my code may not.
As I said in another reply, I'm fishing for ideas on how to display
these options in the web client, for the user's benefit.
I usually just give the user a preset list of options for how many items
to display per page (10, 25, 50, 100). Then they can just page through
the results. I often will display this at the top right corner of the
list. You could also use some kind of preferences page if you have
users that log in.
I like to display the page options at the bottom in this format:
< Prev 1 2 ... 7 8 *9* 10 11 ... 19 20 Next >
By always showing the first 2 and last 2 pages, the user has an easy way
to first and last page and they get an idea of how many pages there are.
There's no need to have a special 'First' and 'Last' link if you do it
this way.
Here is a good site with tips and examples of pagination:
http://www.smashingmagazine.com/2007/11/16/pagination-gallery-examples-and-good-practices/
Hope this helps.
Regards,
Bradley C Bailey
##### CGI::Application community mailing list ################
## ##
## To unsubscribe, or change your message delivery options, ##
## visit: http://www.erlbaum.net/mailman/listinfo/cgiapp ##
## ##
## Web archive: http://www.erlbaum.net/pipermail/cgiapp/ ##
## Wiki: http://cgiapp.erlbaum.net/ ##
## ##
################################################################