Re: database stuff

Hello Tomas, On 30-Jul-01 09:45:16, you 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. Yes, Metabase does not need you to first call a function to fetch a row. Any whole row fetching is done by the driver classes if needed. Some driver classes don't need it. It is one less call for Metabase users to do. >>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. Actually, Oracle supports it with OCIRowCount. Maybe you meant with the ORA interface. Regards, Manuel Lemos Web Programming Components using PHP Classes. Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org -- E-mail: mlemos@acm.org URL: http://www.mlemos.e-na.net/ PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp --