Thursday, April 1, 2010

Re: find() using multiple references to the same table

Thanks, Paul. That did the trick!

I actually read that page, but figured that it didn't apply in this
case because the data from the other tables was being returned
already.

The condition I've been trying to get is on CurrentSchool.name as part
of a filter for the list of applicants.

Thanks again for your help.

~Ryan

On Mar 30, 12:39 am, WebbedIT <p...@webbedit.co.uk> wrote:
[snip]
> Application belongsTo School
> Application belongsTo Student
> Student belongsTo School
[snip]
> $this->Application->bindModel(array(
>   'belongsTo' => array(
>     'CurrentSchool' => array(
>       'className' => 'School',
>       'foreignKey' => false,
>       'conditions' => array('Student.school_id = CurrentSchool.id')
>     )
> ), false);
>
> For more info on ad-hoc joins see:http://book.cakephp.org/view/86/Creating-and-Destroying-Associations-...
[snip]

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

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

To unsubscribe, reply using "remove me" as the subject.

No comments: