Re: Oracle SQLPlus and PHP OCI8 returning different results
| From: | Gozer | Date: | Thu, 01 May 2003 21:21:36 +0000 |
| Subject: | Re: Oracle SQLPlus and PHP OCI8 returning different results | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27481@lists.php.net to get a copy of this message | ||
As I've discovered, and I should have explained more in my first post, the
OCIFetchStatement does not work as advertised unless I'm missing something?
I had hoped to use OCIFetchStatement, however inefficient, to get the number
of result rows. I have since switched to OCIFetchInto and I at least get
the results I expect. However, I cannot get the number of results found
without fetching all of them first. I've seen it stated that using
OCIRowCount after the first fetch might give you the total results, but it
does not. It only gives your current row. So, I'm now faced with the
undesirable option of selecting twice or fetching everything, every time.
Am I missing something with the OCIFetchStatement function? Is it a bug?
Thanks,
Gary