Re: add subquery to every find-statement in beforeFind

Since you may not want to do this for every find call for your model, you might want to setup a custom find type.
Then you could either add additional conditions and nested conditions & sub-queries to the original request, or possibly use the Model::query() call

Check out this page for some examples
http://book.cakephp.org/2.0/en/models/retrieving-your-data.html

HTH,
bill

On 11/2/2012 11:11 AM, Mathias R [via CakePHP] wrote:

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 [hidden email].
To unsubscribe from this group, send email to [hidden email].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
 
 

---

If you reply to this email, your message will be added to the discussion below:

http://cakephp.1045679.n5.nabble.com/add-subquery-to-every-find-statement-in-beforeFind-tp5712054.html

To start a new topic under CakePHP, email [hidden email]
To unsubscribe from CakePHP, click here.
NAML

---

View this message in context: Re: add subquery to every find-statement in beforeFind
Sent from the CakePHP mailing list archive at Nabble.com.

--
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.