Forum OpenACS Development: Pagination without listtemplate

Collapse
1: Pagination without listtemplate
Posted by Iuri Sampaio on 07/18/18 11:37 PM
Hi there,

I'm looking for a code sample for datasource pagination without using listtemplate.

Meaning, I'm only using multiple structure in the ADP file, and db_multirow in the TCL file. So far, there is no example in the whole repository from OACS CSV head's source.

Best wishes,

Collapse
2: Re: Pagination without listtemplate (response to 1)
Posted by Benjamin Brink on 07/19/18 07:58 AM
Hi Iuri,

The ecommerce package has pagination for displaying products in a category (or no category) that uses MULTIPLE and db_multirow:
For no category:
http://cvs.openacs.org/browse/OpenACS/openacs-4/packages/ecommerce/www/index.adp?hb=true
http://cvs.openacs.org/browse/OpenACS/openacs-4/packages/ecommerce/www/index.tcl?hb=true

Also, this link shows an alternate way for pagination for up to tens of thousands of items:
https://openacs.org/forums/message-view?message_id=5394764

It uses the proc qfo_sp_table_g2.
It does not use MULTIPLE or listtemplate or db_multirow.

To use qfo_sp_table_g2 , supply a tcl list of lists representing a table in the same way that db_list_of_lists works, and a couple other parameters related to sorting and column names.

For just pagination, this proc provides the calculations: hf_pagination_by_items I used an early version of it for paginating over 35,000 products in a modified version of ecommerce a little over 10 years ago. The old version is at ecommerce/lib/pagination-bar.adp (and .tcl)

cheers,
Ben