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
[email protected]
To unsubscribe from CakePHP, click
here .
NAML
--
View this message in context:
http://cakephp.1045679.n5.nabble.com/add-subquery-to-every-find-statement-in-beforeFind-tp5712054p5712063.html
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 [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
