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
-~----------~----~----~----~------~----~------~--~---
