В 15:34 +0200 на 08.07.2011 (пт), Marco Pivetta написа: > 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.
I agree. It's not simple but I'm sure it will be helpful to a lot of people. I would like to contact paginator developer, maybe he will like the idea. Do you know how? Regards, S. > 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] > > > > > > -- List: [email protected] Info: http://framework.zend.com/archives Unsubscribe: [email protected]
