http://bakery.cakephp.org/articles/view/basic-pagination-overview-3
http://cake.insertdesignhere.com/posts/view/16 On Jun 25, 8:22 pm, "Jonathan Langevin" <[EMAIL PROTECTED]> wrote: > nice find, how'd you come across that? > > On 6/25/07, kionae <[EMAIL PROTECTED]> wrote: > > > > > Seems there's yet another way to do it (would have been nice if I'd > > found it about 6 hours ago, but meh... what can ya do? XD ), if you > > fancy setting the default sort order for the entire controller rather > > than doing each function on its own. > > > You can set: > > > var $paginate = array('order'=>array('field_name' => 'desc')); > > > at the beginning of your controller, and get the same effect. > > > On Jun 25, 4:54 pm, "Jonathan Langevin" <[EMAIL PROTECTED]> wrote: > > > BTW, as I mentioned, you can pass the parameters via url as well (i've > > been > > > playing with it now, hehe) > > > > i.e. - > > > /cake/app/content/contentList/?limit=5&page=4&sort=parent_id&direction=desc > > > > etc > > > > i believe limit can also be replaced by "show" > > > > On 6/25/07, kionae <[EMAIL PROTECTED]> wrote: > > > > > I knew it had to be something ridiculously easy. :) Both ways seem > > > > to work. Thanks! > > > > > On Jun 25, 2:36 pm, "Jonathan Langevin" <[EMAIL PROTECTED]> wrote: > > > > > Apparently another way is to do: > > > > > $this->params['order'] = array(); > > > > > $this->params['order']['id'] = 'desc'; > > > > > > On 6/25/07, Jonathan Langevin <[EMAIL PROTECTED]> wrote: > > > > > > > Where are you calling paginate from? in your controller? > > > > > > if so, just try > > > > > > $this->params['sort'] = 'id'; > > > > > > $this->params['direction'] = 'desc'; > > > > > > > before you call $this->paginate(); > > > > > > > On 6/25/07, kionae <[EMAIL PROTECTED]> wrote: > > > > > > > > The problem with that is that I can't figure out how/where to > > set > > > > > > > them. They don't seem to come from the parameters passed > > through > > > > the > > > > > > > paginate function in the controller, but rather from the > > $options > > > > > > > array and I don't know how to set things in the $options array. > > > > > > > > On Jun 25, 1:56 pm, "Jonathan Langevin" <[EMAIL PROTECTED]> > > wrote: > > > > > > > > According to cake/libs/controller/controller.php (function > > > > paginate), > > > > > > > it > > > > > > > > appears you need to set "sort" and "direction": > > > > > > > > sort => true > > > > > > > > direction => 'asc'|'desc' > > > > > > > > > it will check $this->params, $this->params['url'], and > > > > > > > $this->passedArgs, so > > > > > > > > try it in your url, might be the easiest test for now > > > > > > > > > On 6/25/07, kionae <[EMAIL PROTECTED]> wrote: > > > > > > > > > > The problem is not getting paginate in 1.2 to work, but > > rather > > > > > > > > > changing the default sort order. Everything is sorted in > > > > ascending > > > > > > > > > order on the ID field when the page initially loads, but I > > need > > > > it > > > > > > > in > > > > > > > > > descending order on the date field... and for the life of > > me, I > > > > > > > can't > > > > > > > > > find any way to specify this when calling $this->paginate() > > in > > > > the > > > > > > > > > controller. The API has been less than helpful, as all it > > has > > > > to > > > > > > > say > > > > > > > > > about paginate is: > > > > > > > > > > Controller::paginate ( $object = null, > > > > > > > > > $scope = array(), > > > > > > > > > $whitelist = array() ) > > > > > > > > > > Handles automatic pagination of model records > > > > > > > > > Parameters: > > > > > > > > > mixed $object > > > > > > > > > mixed $scope > > > > > > > > > array $whitelist > > > > > > > > > > There has to be some way to tell it to spit things out in > > > > descending > > > > > > > > > order on whichever field I specify, instead of the default > > > > ascending > > > > > > > > > > order on the ID field... I know I'm probably missing > > something > > > > > > > > > stupidly easy, but I can't figure it out. Help? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
