'order' => 'Model.column DESC'

On Wed, May 7, 2008 at 11:26 AM, Tim W <[EMAIL PROTECTED]> wrote:
>
>  Thanks for the suggestion, but unfortunately it didn't work for me.
>
>  SQL Error: 1054: Unknown column 'DESC' in 'order clause'
>
>  I'll spend some time to work this out at some point, i'll post when I
>  do, unless someone's worked it out already and can tell me.
>
>  Thanks
>
>  Tim
>
>
>
>  On May 7, 8:11 pm, "Andras Kende" <[EMAIL PROTECTED]> wrote:
>  > Hello,
>  >
>  > try this in your controller:
>  >
>  > var $paginate = array('limit' => 100, 'page' => 1, 'order' => 'DESC');
>  >
>  > Andras Kende
>  >
>  > http://www.kende.com
>  >
>  > -----Original Message-----
>  > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
>  >
>  > Of Tim W
>  > Sent: Tuesday, May 06, 2008 9:26 AM
>  > To: CakePHP
>  > Subject: Making Paginator first sort direction DESC
>  >
>  > Hi all,
>  >
>  > Paginator's great, like the rest of Cake, but there's one little thing
>  > I haven't been able to work out. By default when you click on a column
>  > to sort it will sort ASC (ascending), but i'd like the first sort to
>  > be DESC (descending). The options suggest this might be possible, but
>  > I haven't worked it out. Does anyone know if this is possible?
>  >
>  > Thanks
>  >
>  > TIm
>  >
>



-- 
Marcin Domanski
http://kabturek.info

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

Reply via email to