Re: CakePHP Containable on Associated Model

Hi,

Let me try to clarify because I think I've confused even myself at
this point lol

I have 3 books that I am trying to retrieve from the database. Users
have added these books to reading logs, but I want to return each
book, and then only the logs where the user id is equal to the current
user (lets say two)
right now using Log.user_id = 2 i get the following array

Book 1
Empty log array

Book 2
log array, userid = 2

Book 3
log array, userid = 2
log array, userid = 3

That third book, where the extra log is returned is what I don't want
happening. Does this make more sense?

On May 6, 1:06 am, bs28723 <bill.sto...@boosterwebsolutions.com>
wrote:
>     Are you looking for a find where&nbsp; "Log.user_id=2 OR Book.log_id =
>     null"?
>
>     On 5/3/2012 11:00 PM, Rob-3 [via CakePHP] wrote:
>      I have a setup where there are Books Users and Logs.
>       Each Log has a
>
>       Book and a User and I am trying to retrieve a list of all the
>       books
>
>       regardless of the user, but then also retrieve the Logs associated
>
>       with that book (recursive is set to 1), but then only retrieving
>       the
>
>       logs of the current logged in user.
>
>       Hopefully that's clear. I tried using Containable and like so:
>
>       $this-&gt;Book-&gt;contain('Log.user_id = 2');
>
>       But unfortunately this leaves out Books for which User 2 has no
>       logs
>
>       for. Am I going about this correctly and I'm just not using
>
>       containable properly, or am I doing this all wrong.
>
>       Let me know if anything needs to be clarified or expanded...Any
>       help
>
>       is appreciated!
>
>       --
>       Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org&nbsp;
>
>       Check out the new CakePHP Questions sitehttp://ask.cakephp.org&nbsp;and
>       help others with their CakePHP related questions.
>
>       To unsubscribe from this group, send email to
>
>       [hidden email]
>       For more options, visit this group athttp://groups.google.com/group/cake-php
>
>         If you reply to this email, your
>           message will be added to the discussion below:
>        http://cakephp.1045679.n5.nabble.com/CakePHP-Containable-on-Associate...
>
>         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/CakePHP-Containable-on-Associate...
> Sent from the CakePHP mailing list archive at Nabble.com.

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php