The easiest way would be to Use countercache and then just add post_count > 0 to conditions... if you cant zdf countercache for some reason you could also inner join the posts Table, which would leave all blogs that have no assocciated post... On 1 Nov., 18:29, Max D <[email protected]> wrote: > Hi, > > i use cake 1.3 and I have a "Blog hasMany Post" association and now I > want to find all the Blogs, which have at least one Post. I use the > Containable Behavior. > > I understand, that I could do a Blog->find('all', array('contain' => > array('Post'))) and simply filter the results for the Blogs, where the > Post array is empty. > But this doesn't work if I want to use pagination. > > I tried to paginate over the Post model: > $this->paginate = array('Post' => array( > 'contain' => array('Blog'), > 'order' => 'Blog.created DESC', > 'group' => 'Post.blog_id', > 'limit' => 5, > )); > $blog = $this->paginate('Post'); > > The Blog array looks good. I just get the Blogs with one Post each > (which I don't actually need). But all the PaginatorHelper functions > return wrong results. > $this->Paginator->counter(array('model' => 'Post')); > always returns 1, although there are 3 results in the $blogs array. > > Any ideas how I can achieve this? > Thanks in advance > Max
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
