[0] => Array ( [Incident] => Array ( [id] => 37 [start_date] => 2010-10-08 [exp_date] => 2010-10-14 [incoming_num] => 453-10 [incoming_date] => 2010-10-08 ) [Detail] => Array ( [0] => Array ( [id] => 98 [incident_id] => 37 [comment_id] => 1 [comment_date] => 2010-10-11 10:07:29 [notify_only] => 0 )
[1] => Array ( [id] => 99 [incident_id] => 37 [comment_id] => 2 [comment_date] => 2010-10-11 17:01:09 [notify_only] => 0 ) [2] => Array ( [id] => 100 [incident_id] => 37 [comment_id] => 3 [comment_date] => 2010-10-12 09:08:01 [notify_only] => 0 ) ) ) [1] => Array How can I select only those Incident.id, whose last Detail.comment_date < Incident.exp_date? Is it possible to compare in cakephp fields from different tables? Thans as advance for any assistant. -- 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
