+-------+ +-------+ +-------+ +-------+
| A |1____N| B |1____N| C |1_____N| D |
+-------+ +-------+ +-------+ +-------+
A stupid question, but could someone explain howto identify which
objects of type D that has grandparent A.id.
Pseudocode: $dmodels = $this->ModelD->find('all', array('A.id'=>
$userid));
thus finding all leaves of model D that originates from a specific
model A.
I've tried changing the recursive level between -1 to 2, without
identifying the grandparents.
I've also tried using join, but I am not sure how to join tables. Left-
join or inner join???
The result must also be paginated according to specific pagination
settings...
In model C, I could use the following code to identify all object of
type C that has grandparent A.id
/* Sample code */
$this->paginate['ModelC'] = array(
'contain' => array('ModelA', 'ModelB'),
'conditions' => array('ModelB.modela_id'=>$usrid)
);
$cmodels = $this->paginate('ModelC');
$this->set('cmodels',$cmodels);
/* end of sample code */
TIA,
Jimson
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
