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.

    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 &amp; 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 &gt;= time() and
      end &lt;= 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
      &nbsp;
      ---
      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 .
      &nbsp;
      &nbsp;

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

        To start a new topic under CakePHP, email
        ml-node+s1045679n125572...@n5.nabble.com  
        To unsubscribe from CakePHP, click
          here .
        NAML  

--
View this message in context: http://cakephp.1045679.n5.nabble.com/add-subquery-to-every-find-state...
Sent from the CakePHP mailing list archive at Nabble.com.