If you want, you can use these two functions in your model to do custom paginating...
http://bin.cakephp.org/saved/21687 On Sep 25, 8:37 am, burzum <[EMAIL PROTECTED]> wrote: > I have this query here that gets an average value from the errands > table for each employee and i want to paginate it. How can i do it!? I > don't get it. I've wasted already 4 hours on this "problem" and > looking trough the API and the pagination helper... :( > > Any ideas how to do it in a nice way? > > SELECT Employee.id, Employee.vorname, Employee.name, > Errand.ausgangsdifferenz ,AVG(Errand.ausgangsdifferenz) AS > durchschnitt > FROM `employees` AS `Employee` > LEFT JOIN `errands` AS `Errand` ON > (`Errand`.`monteur_id` = > `Employee`.`id`) > GROUP BY Employee.id > ORDER BY Employee.name DESC > LIMIT 0,5 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
