tags:

views:

319

answers:

1
Q: 

CakePHP find('threaded') pagination

Hi,

I'm kind of new to cakePHP and get to the moment where i have to do pagination.

The comments table has a parent_id and the threaded query is working correctly so now, I want to paginate the results.

My problem is the limited sql query affects all the retrieved comments and I only want to limit the parent ones because the other way, it leaves replies out of the query.

Hope I'd be clear and you can help me.

Thanks.

A: 

You probably need to do the query for just the parents (topics?) then another query for each tree below that.

Leo  2010-01-26 12:15:14

related questions

Pagination in CouchDB?
Offset vs page number when doing pagination
Pagination Problem [PHP]
How to perform page control?
Paged table with ASP.NET MVC and AJAX
Can You "Assign" the PageCount Property of an ASP.NET GridView?
How do you implement pagination in PHP?
Default to last page in a ListView
Paginated query using sorting on different columns using ROW_NUMBER() OVER () in SQL Server 2005
Is there a name for this type of page navigation?
PHP Dynamic Pagination Without SQL
What is an efficient method of paging through very large result sets in SQL Server 2005?
Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
Smart pagination algorithm
Why doesnt paginator remember my custom parameters when I go to page 2?
JSP pagination without retrieving the whole result set?
Different odd/even pages in MS Access reports
Caching paginated results, purging on update - how to solve?
What is the best way to paginate results in MS SQLServer
What is the best way to paginate results in php
Keep pagination repeatable if change operations are performed
How can you do paging with NHibernate?
Is there an ASP.NET pagination control (Not MVC)?
Why is pagination so resource-expensive?
How to return a page of results from SQL?