Re: how to use counterquery in cakephp

I think you'll need to write your own custom function for that and put in the afterSave callback of the 'Wheel' model.

Jeremy Burns
Class Outfit

jeremyburns@classoutfit.com
http://www.classoutfit.com

On 25 Mar 2011, at 11:39, Zeu5 wrote:

> Hi
>
> i need help understanding counterquery
>
> i know right now cakephp allows me to store children count in parent
> table
>
> eg a Car hasMany Wheel
>
> so in cars table, there is a wheels_count column.
>
> but i only want to store the wheel associated with a particular car
> AND has a status as 'active'.
>
> Meaning, if 5 Wheel records belong to a Car with id = 17, but of these
> 5 only 3 of them have a Wheel.status = 'active', then the
> Car.wheels_count for id 17 is 3.
>
> so apparently counterquery helps me to do this?
>
> Please enlighten me.
>
> Thank you.
>
> --
> 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+unsubscribe@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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php