hey dood, a similar topic was discussed previously.
http://groups.google.com/group/cake-php/browse_thread/thread/0619a260787661ea/87cce0cefa2039be#87cce0cefa2039be some of the ideas in there might help you out. cheers, freedom On 27/09/06, benstof <[EMAIL PROTECTED]> wrote: > > I currently have a habtm association between the models, user and room. > I also have a belongsTo and hasMany between room and comment. > > What I would like to do is query the user model so that a specific > room's comments are shown to a specific user. This would require to > state a where for the user_id and the room_id in the join table. > > I would like to solve this without creating a model for the join table, > althought that might end up being a current solution. > > The current query in the users_controller looks like this: > > $this->set('user', $this->User->find(array('User.id' => 1), null, null, > 2)); > > This shows me all the rooms assocaited with user with id as 1. I want > to limit the rooms, and show only, lets say, room with id 2. > > Any suggestions on adapting my query to do that? Or is there a better > way to do this? > > Any other clean and simple sollutions will be appreciated. > > Regards. > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
