Re: how to use counterquery in cakephp

By the way - have a go and come back if you can't get it to work.

Jeremy Burns
Class Outfit

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

On 25 Mar 2011, at 12:10, Zeu5 wrote:

> Thank you Jeremy.
>
> Would you give me a bit more details?
>
> some example code perhaps?
>
>
> On Mar 25, 8:06 pm, Jeremy Burns | Class Outfit
> <jeremybu...@classoutfit.com> wrote:
>> 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
>>
>> jeremybu...@classoutfit.comhttp://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 Tutorialshttp://tv.cakephp.org
>>> Check out the new CakePHP Questions sitehttp://ask.cakephp.organd 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 athttp://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

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