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 "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->Book->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
>
> Check out the new CakePHP Questions sitehttp://ask.cakephp.org 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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
