I think it might be Syntax, try:

$query = $this->PhdUser->find('all', array(
 
'contain'=>array(
 
'PhdCollege'=>array('dateLeft' => 'max(dateLeft)'),
 
'PhdApplication'=>array('userID' => '"6240"'),
 
'PhdTest'
                                                                ),

A work around method... I don't think i would recommend it but does
kind of get the job done..

In your model set:

var $order = 'dateLeft';

then instead of using find('all') use find('first') with no parameters

Good Luck
Cheers
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to