add subquery to every find-statement in beforeFind

Hi,

i have a model which belongs to another like "model car belongs to rent-time".
in table for rent-time there are two timestamps (start and end).
now i want to modify every find-statement for model car and add a subquery like this:

select *, (select id from rent-time where start >= time() and end <= time() and car_id = $car_id limit 0,1) as rent-time from car

is it possible to modify original statement to add a subquery?

M.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.