Re: How to get records for a model based on it's id existing in a linking table?

Lamiunto,

Thank you for the prompt response. I was needlessly overcomplicating
things by going through the $this->Collection->Recipient->find()
instead of simply $this->Collection->find(). Sometimes I can be such a
knucklehead.

Many thanks!

On Mar 29, 2:29 am, Lamiunto <shaun.steenk...@gmail.com> wrote:
> Cake should be doing that for you anyway. Have you tried getting your
> data through the Collection model? Should be:
>
> $data = $this->Collection->find('first', array('conditions' => array
> ('Collection.id' => $id)));
>
> Where $id is 15, or any other id number. That should find all the
> recipients associated with the requested Collection record.
> In your result set, you would access all the returned recipients like
> normal, ie. $data['Recipient'][...];
>
> On Mar 29, 5:11 pm, Drinkspiller <drinkSpil...@gmail.com> wrote:
>
> > I have two models, Collection and Recipient that have a HABTM
> > relationship. The database has a collections_recipients liking table.
>
> > Using a specific collection_id, how do I do a find() that gets all
> > Recipients that are associated with the collection_id in the linking
> > table? I want the end SQL to look like thishttp://bin.cakephp.org/view/2145898894
> > (where I supply the id of 15 as the value of the collection_id
> > variable)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en
-~----------~----~----~----~------~----~------~--~---