On 3 Jun 2012, at 18:30, stork wrote:

> Add counterCache field to categories table and then use that field in 
> find('list') conditions.
> http://book.cakephp.org/1.3/en/view/1033/counterCache-Cache-your-count

Very quick and neat, thanks for that.

I added the product_count field to my product_categories table. Then added 
'counterCache' => true to my products model and...
'conditions' => array('ProductCategory.product_count >' => 0)
…to my products_controller find

Up and running.

Paul

-- 
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

Reply via email to