How do you have your Models setup? Book $hasMany = array('Log' => array('className' => 'Log', 'foreignKey' => 'book_id')); $belongsTo = array('User' => array('className' => 'User', 'foreignKey' => 'user_id')); Log $belongsTo = array('Book' => array('className' => 'Book', 'foreignKey' => 'book_id'), 'User' => array('className' => 'User', 'foreignKey' => 'user_id')); If it is setup like this and you have user_id field in books table, then it should work. If Book does not have user_id, then you may have to do something like a sub query of Log.user_id=2, and then join that with Book on book_id. or something like that. Can you create a mySQL statement to pull the data out? if so, then post the SQL and maybe someone can help explain how to do this. HTH. Bill On 5/6/2012 6:33 PM, Rob-3 [via CakePHP] wrote: 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 < [hidden email] > 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 > [hidden email] > 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 [hidden email] For more options, visit this group at http://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-Associated-Model-tp5684781p5689882.html 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-Associated-Model-tp5684781p5692635.html 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