[PHP-DEV] PHP 4.0 Bug #1944 Updated: I can't get right result number when using IFX_AFFECTED_ROWS() From: Bug Database (php-dev <email protected>)
Date: 08/02/99

ID: 1944
Updated by: danny
Reported By: musica98 <email protected>
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

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>