how to pass the result of custom query in pagination

Question

hi i am using cakephp for my project but i have problem when i generate result from custom query. then i have no idea about that how to that result in to pagination. so please help me.

thanks in advance.

Answer 1

This is covered in the book (http://book.cakephp.org/view/249/Custom-Query-Pagination)

Bascially, you would override paginate in the model you want to get the data from. If it will mess up the model, just create a new custom model that uses the same table and put the paginate override in there.