Yep, doesn't seem to work as it returns all the posts.
On Monday, June 25, 2012 3:21:15 PM UTC+10, Борислав Събев wrote: > > Have you tried configuring the paginator in your Controller with a limit > of 10: > > public $paginate = array( > 'limit' => 10, > 'order' => array( > 'Post.title' => 'asc' > ) > ); > > > > On Monday, 25 June 2012 04:14:32 UTC+3, 42startups wrote: >> >> Ah ok, so how would I paginate and limit results to 10?... >> >> $this->loadModel('Tag', $id); >> $tag = $this->Tag->read(); >> >> On Monday, June 25, 2012 6:11:55 AM UTC+10, JonStark wrote: >>> >>> I find it easier to use LoadModel to display and sort posts from HABTM... >>> >>> Le dimanche 24 juin 2012 10:40:04 UTC+2, 42startups a écrit : >>>> >>>> Wow, CakePHP really hasn't got this problem sorted. >>>> >>>> After hours of searching I came across the solution below (which may or >>>> may not be outdated), but I'm having issues applying paginatior 'limit' => >>>> 10 or other ordering. >>>> >>>> Any ideas what I'm missing? >>>> >>>> My model: >>>> >>>> public $hasAndBelongsToMany = array( >>>> 'Post' => array( >>>> 'className' => 'Post', >>>> 'joinTable' => 'tags_posts', >>>> 'foreignKey' => 'tag_id', >>>> 'associationForeignKey' => 'post_id', >>>> 'order' => array('Post.created DESC'), >>>> 'unique' => true >>>> ) >>>> ); >>>> >>>> In my controller in view() >>>> >>>> public function view($id) { >>>> $this->Tag->bindModel(array('hasOne' => array('TagsPost')), false); >>>> >>>> $this->set('tag', $this->paginate('Tag', array('TagsPost.tag_id' => >>>> $id))); >>>> } >>>> >>>> In my view I then had to change: >>>> >>>> foreach ($tag['Post'] as $post) >>>> >>>> to >>>> >>>> foreach ($tag[0]['Post'] as $post) >>>> >>>> -- 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