Re: Browse database records [RFC]

On Tuesday 30 October 2001 15:46, Bertrand Mansion wrote: > Le mardi 30 octobre 2001, à 02:56 , gus a écrit : > > Martin Jansen schrieb: > >> Just to get you right: Do your classes provide something similar > >> to http://vulcanonet.com/soft/?pack=pager? > > > > Yes, this functionality is integrated (template based) in the > > DBGrid, too. Just > > the pages feature (1 2 3 4 5 ...) isn't implemented yet. > > I haven't discovered the Pager class in the PEAR CVS. If it could > > be commited it > > seemed that it should be no problem to integrate it in my classes. > > Is this pager thing compatible with Oracle ? > If so, it would be quite interesting to see how you handle this as > oracle sql does not have 'limit'. > Not at all. The Oracle PHP api has many limitations, for example doesn't have numRows or a way to retrieve only sets of results, making Oracle incompatible with the automatic fetchrow feature of the Pager Class. (what people do to paginate rows in Oracle? fetch all and only show the rows between a range?) The same occurs with Interbase. Any way, one can always use the data provided by the class to represent all the things related to paginated result sets (all of them automatically calculated by the Pager class). Tomas V.V.Cox