I wrote a small example on this a while back, can be found here :-
http://wiltonsoftware.com/posts/view/custom-group-by-pagination-and-a-calculated-field

On Wed, Mar 4, 2009 at 6:22 PM, Rimoe <meiyo...@gmail.com> wrote:
> hi,
> I have write a
> var $paginate = array(
>         'limit' => 50,
> 'fields' => array('acc_id', 'count(*) as countnum'),
>         'order' => array('countnum ' => 'desc'),
> 'group' => array('acc_id')
>     );
> the paginate  can't get the paginate's count,
>
> can't pagination use the group by ?
> or how to use the group by in paginate.
>
> Thanks
> rimoe
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to