That doesn't work either as I can't the following returns a
Staff.Person.organisation_id SQL error
$this->Staff->bindModel(array(
'belongsTo'=>array(
'Organisation'=>array(
'foriegnKey'=>'Person.organisation_id'
)
)
));
I then tried to use paginate on $this->Staff->Person as that would
allow me to access the Organisation table properties, whilst still
pulling out Staff details, but this seems the wrong way to do it and
would entail removing a lot of relations I do not require from the
Person model.
Surely there is a simpler way to paginate data from my Staff model
filtered by a field in a table two belongsTo associations away? All I
need is for Cake to join these three tables together by their
belongsTo associations. I've been stuck at this point for over a week
now and would be hugely grateful to anyone who can help me out.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
