Forum OpenACS Development: problem with list builder

Collapse
Posted by SriHarsha Chintalapani on
hi all..I got a problem with list builder .My openACS version is 5.14.

template::list::create \
-name bindings \
-page_size 10 \
-page_groupsize 10 \
-page_query valid_installed_binding \
-elements {
country_code {
label "COUNTRY CODE"
}
country_name {
label "COUNTRY NAME"
}
}
db_multirow bindings valid_installed_binding {}

i am limiting list builder for 10 rows per page using page_size but it is printing all the rows in my table in one page. I gone through the code of list builder i think the problem is with "multirow" it's not limiting the query

like "select country_code,country_name from countries offset 0 limit 10".
even if i mention two different queries for "page_query" "multirow". The one in "multirow" will be getting executed.

I am going through the code.If someone has solution or any suggestions please help me

Collapse
Posted by Malte Sussdorff on
You have to specify two different queries. One for pagination, returning the ID's and one for the actual query. Take a look at our Tips & Trips section at http://www.cognovis.de/entwickler/tips/listbuilder/. There is a section on "Pagination". This should help.