Hi AD, I have seen the "counterQuery" option for hasMany association but do not know much about it .. Do you have some usage sample of this ??
Cheers Franck On Feb 25, 9:29 am, AD7six <[EMAIL PROTECTED]> wrote: > Adam Royle wrote: > > If you want to sort on the column as well, I suggest you create a > > "counter cache". Basically, you store the count of subitems in a field > > in the main table, which is updated on create/update/delete. > > > There is even a behaviour that can do this automatically for you. > > >http://bakery.cakephp.org/articles/view/countercache-or-counter_cache... > > 1.2 has that functionality built in now (not sure since when, but I've > been using it for a few months I think). > > e.g. > <?php > class Comment extends AppModel { > var $belongsTo = array( > 'Blog' => array( > 'counterCache' => true, > 'counterScope' => array('Comment.status' => '> 0') > ) > );} > > ?> > > hth, > > AD --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
