Re: result set pointer method in DB?
| From: | Tomas V.V.Cox | Date: | Mon, 10 Sep 2001 09:54:55 +0000 |
| Subject: | Re: result set pointer method in DB? | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-1861@lists.php.net to get a copy of this message | ||
Marc Logemann wrote:
>
> Hi,
>
> wouldnt it be useful to have a method for
> manipulating the result set pointer in PEAR:DB?
>
> Please correct me if i am wrong, but right now
> you can do something like
>
> $res->fetchRow($fetchmode, 0)) but this wont
> solve it exactly.
>
> Assume something like this:
>
> SQL = "some sql"
> RES = DO QUERY
> while($row = RES->fetch) DO SOMETHING IN A LOOP
>
> MOVE RES POINTER to 0
>
> while($row = RES->fetch) DO SOMETHING DIFFERENT IN A LOOP
>
> I cant see how to achieve this with the current PEAR:DB
> in an elegant way...
>
> I dont know all supported databases of course, but this
> should be a feature each database is capable of or?
http://marc.theaimsgroup.com/?l=pear-dev&m=99918060218641&w=2
(all drivers except ibase and oci8)
Tomas V.V.Cox