PHP 4.0 Bug #1944 Updated: I can't get right result number when using IFX_AFFECTED_ROWS()
| From: | Bug Database | Date: | Mon, 02 Aug 1999 09:33:10 +0000 |
| Subject: | PHP 4.0 Bug #1944 Updated: I can't get right result number when using IFX_AFFECTED_ROWS() | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-9442@lists.php.net to get a copy of this message | ||
ID: 1944
Updated by: danny
Reported By: musica98@chollian.net
Status: Closed
Bug Type: Other
Assigned To:
Comments:
As stated in the manual, ifx_affected_rows() can only give
an ESTIMATE for SELECT type queries.
The number returned by ifx_affected_rows()is only exact for
INSERT/UPDATE type queries.
This is a limitation of the Informix database. There are no
work-arounds.
You can read up on this in the Informix ESQL/C Programmer's
Manual, SQLCA structure, fields sqlerrd[0] and sqlerrd[2].
If you really need this number, you can excute a "select
count(*)", but don't complain about performance problems
if you do.
Danny.
---
Full Bug description available at: http://bugs.php.net/version4/?id=1944