Re: database stuff

Manuel Lemos wrote: > > 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. Pear DB has support for this. You only need to pass the row number to the fetch(Row|Into) statement. If I didn't undertand bad, he was asking for a way of doing this without fetching the row. >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 > Thanks Manuel I'll do it, but now only Oracle and Interbase don't support it and seems that users haven't request it. Tomas V.V.Cox