Sorry to bother..... I figured it out. Dave _____
From: Dave Maharaj :: WidePixels.com [mailto:[email protected]] Sent: May-18-09 1:48 AM To: [email protected] Subject: Contain question I am trying to contain a query, but the question comes basically from this situation. Site has Posts which a User can bookmark, I have the contain working fine so far, pulls the logged in users saved Posts. Problem is the owner of each Post can set the Post to Published or Not Published so when the Logged in user views the saved posts list if they had originally saved a post that was published and since has been set to Not Published i do not want that bookmark to appear. The bookmark table only holds the post_id and the user_id not the Post.status(0 or 1) so what i did was 'contain' => array( 'Bookmark' => array('fields' => array('Bookmark.id'), 'Post' => array( 'conditions' => array('Post.status' => '0'), 'fields' => array('Post.id'))), Buts it getting all the bookmarks...how can i limit the bookmarks based on the status of the Post? i guess i could add the post_status to the bookmarks table but surly there must be a way to get the bookmarks of the posts based on the status of the bookmarked posts?? thanks Dave --~--~---------~--~----~------------~-------~--~----~ 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] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
