[phplib] Re: [phplib-dev] affected_rows() with db_oracle.inc From: Kristian Koehntopp (kris <email protected>)
Date: 07/15/00

In netuse.lists.phplib you write:
>But this will only return a value for inserts, updates and deletes. It does
>not return a value for selects.

Oracle is returning rows from a query in an asynchronous fashion
if possible. That is, while your cursor may be happily sucking
rows from the frontend, the backend may still be adding rows to
the result set. It may well be the case that the entire result
is not shown anywhere completely.

In such a system, a count() is the only way to get sizes (and
this forces sycronicity on the server and may be slow, so beware
what you ask for).

Kristian

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>