Re: database stuff

Hello, "Tomas V.V.Cox" wrote: > > On Thursday 26 July 2001 20:51, mailling@bigfoot.com wrote: > > I would like to know if it is possible to add a method to move the > > pointer. Example, I would appreciate a method that use only: (ie. > > given for mysql) mysql_data_seek > > > > And don't mix this job with another one such as in fetchInto > > I don't see how this could fit in the idea of a database abstraction > layer. But always you can do what you want with the cursor as you have > it stored as a property in the pear db result object: > $result_object->result (before Stig beat me, I must say that this > practise is unsopprted and unrecomended :) I think what he is asking is not a big deal but I just don't know if there could be a easy way to do it with PEAR-DB. Anyway, with Metabase you can always pass an arbitrary row number and with that do non-sequential access. It works compatibly with DBMS that only support non-sequential result set access, like Oracle and others. Metabase is smart enough to keep track of the numbers that are buffered. You may want to take a look how it is done by checking its documentation here: http://phpclasses.UpperDesign.com/browse.html/package/20 Manuel Lemos