This keeps on show up in my email. The subject. I was wondering what this was for?
On 10/14/2008, Brenton B <[EMAIL PROTECTED]> wrote: > > Not sure if this is close to what you need, > http://www.bbartel.ca/blog/brenton/2008/oct/14/habtm-searching > (will touch up formatting shortly). > > On Oct 14, 3:16 am, hariharan <[EMAIL PROTECTED]> wrote: >> 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. > > > -- Xavier A. Mathews Student/Developer/Web-Master GG Client Based Tech Support Specialist Hazel Crest Illinois [EMAIL PROTECTED] "Fear of a name, only increases fear of the thing itself." --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
