Hi Bingo, The key to being able to sort is to get the findAll method (or if that turns out to not be direcltly possible your custom, but exactly the same format, sql query) to return you what you want rather than a sql query followed by a php for each loop.
http://groups-beta.google.com/group/cake-php/search?group=cake-php&q=max+nate&qt_g=Search+this+group Why do you have models for your join tables...? You may find that counterCache does what you want regarding the counting how many Songs a singer has, I haven“t needed to use it yet so can't offer more than a point in that direction. HTH, AD7six Please note: The manual/bakery is a good place to start any quest for info. The cake search (at the time of writing) erroneously reports less/no results for the google group. The wiki may contain incorrect info - read at your own risk (it's mainly user submitted) :) You may get your answer quicker by asking on the IRC Channel (you can access it with just a browser here: http://irc.cakephp.org). On Oct 26, 5:08 pm, "bingo" <[EMAIL PROTECTED]> wrote: > hi bakers > > (especially AD7six and Christoph) > Now, I did find a solution for specifying the query, but getting a > trouble on how to set pagination. I want to set the pagination on name, > count or id.... > > any ideas on how to do to set pagination. > > Regards --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
