You can either add a JOIN [1] query for each HABTM association you want to filter on the pagination find, or BIND [2] the join table models (ProductsCategory and ProductsColor) to the Product model as HasOne associations before doing the pagination. Both would require to specify that the join must be INNER and to group the find results by Product.id.
[1] http://book.cakephp.org/view/1047/Joining-tables [2] http://web-development-blog.co.uk/2010/09/14/cakephp-habtm-find-with-conditions-and-containable-behavior/(first example) Cheers, - Johan On Wed, Jun 29, 2011 at 9:54 AM, Cengiz Eselioglu <eselio...@gmail.com>wrote: > Hi. > I would like to paging products with multi Habtm. > My tables: > products > categories > colors > > > And HABTM connections > Product HABTM Categories products_categories > Product belongsTo Color > > How do I make a query like the following? (width : Habtm Pagination) > > Category.id = 3 and Color.id=4 all products > or > Category.id = 3 and Product.color_id=4 all products > > Best Reguards > Cengiz > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php