The Zend_Paginator_Adapter_DbSelect is used to dinamically build a select query and base pagination on it's COUNT and similar results. If you use plain SQL or your own SQL class you should probably emulate the same behavior, and with string queries that is absolutely NOT a simple task. That's why Zend_Db_Select is there... Otherwise just fetch all the data and stuff it into a Zend_Paginator_Adapter_Array and do all required checks before... Marco Pivetta http://twitter.com/Ocramius http://marco-pivetta.com
On 8 July 2011 15:23, saiman <[email protected]> wrote: > В 16:21 +0300 на 08.07.2011 (пт), nevvermind написа: > > There's an array adapter for the paginator: > > > > $paginator = new Zend_Paginator(new > > Zend_Paginator_Adapter_Array($rowsetArray)); > > - or - > > $paginator = Zend_Paginator::factory($rowsetArray); > > > > Where $rowset's the db query result (or any other source). > > > > > Yes, I know about it but what happens if I've got 30 000 rows for > example? In this way I have to load everything inside php mem which is > not "healthy". > > > > On Fri, Jul 8, 2011 at 4:02 PM, saiman <[email protected]> wrote: > > > > > Hello, > > > Is there any way using Zend pagiantor with raw SQL query, not using > > > Zend_Db_Select or Zend_Db_Table_Select. Sometimes I prefer not using > > > those (Zend_Db_*) if query is more complex for example and will be > great > > > if there is such a options for the paginator. > > > > > > Regards, > > > S. > > > > > > > > > > > > -- > > > List: [email protected] > > > Info: http://framework.zend.com/archives > > > Unsubscribe: [email protected] > > > > > > > > > > > > > -- > List: [email protected] > Info: http://framework.zend.com/archives > Unsubscribe: [email protected] > > >
