thx for those links On 6/27/07, dardosordi <[EMAIL PROTECTED]> wrote: > > > > 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 -~----------~----~----~----~------~----~------~--~---
