I am also stuck with the same problem . For HABTM or hasMany it doesnt
query with join. rather queries each and every table in an individual
manner, which is time consuming one.
Another thing is cakephp does not support through association like
ROR. suppose if I have two HABTM then i cant access the fields of the
extra table formed due to the relationships.
eg user and group
users -> HASMANYANDBELONGSTO -> groups
groups -> HASMANYANDBELONGSTO -> users
so the other table result due to this is groups_users. other than
group_id and user_id suppose if i want to store additional info such
as when did they joined group etc... i cant access those fields.....
help me.....
On Oct 8, 1:56 am, jmmg77 <[EMAIL PROTECTED]> wrote:
> Okay,
>
> Whenever I have a hasOne or belongsTo association, those models are
> included in the query whenever I do a find('all');
>
> But, when I have any other type of association, find('all' only
> generates a query with the model I'm searching.
> This keeps me from filtering by fields in the related models.
>
> ex:
> $funnypeople = $this->Individual->find('all', array('conditions' =>
> array('Personality.type' => 3)));
>
> This example works find if a person only has one Personality Type.
> But what about this.
>
> $racecardrivers = $this->Individual->find('all', array('conditions' =>
> array('Vehicle.type' => 2)));
>
> The problem here is a person could own multiple vehicles, so belongsTo
> & hasOne don't work here.
> I would need hasMany or hasAndBelongsToMany, which makes those model
> inaccessible using find.
>
> Any help would be greatly appreciated. Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
