OK so you have the following
Application belongsTo School
Application belongsTo Student
Student belongsTo School
In order to run a find on Application but place a condition on the
Student's current school you need to force a join using bindModel() as
follows
$this->Application->bindModel(array(
'belongsTo' => array(
'CurrentSchool' => array(
'className' => 'School',
'foreignKey' => false,
'conditions' => array('Student.school_id = CurrentSchool.id')
)
));
If you are going to paginate your result you need to add a false
parameter to make this permanent (but only for this HTTP request)
$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-on-the-Fly
Now you can run the following find
$this->Application->find('all', array(
'conditions'=>array(
'Application.school_id'=>$school_id,
'CurrentSchool.name'=>$school_name
)
));
However, if you are using and id for searching the applied to school,
why are you not able to use an id for the current school (by providing
a select list)? Then you could just apply the condition to
Student.school_id and not have to force any joins.
HTH
Paul.
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 [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
To unsubscribe from this group, send email to
cake-php+unsubscribegooglegroups.com or reply to this email with the words
"REMOVE ME" as the subject.
