php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #2410 ifx_affected_rows error
Submitted: 1999-09-29 21:46 UTC Modified: 1999-10-03 23:22 UTC
From: kangkw at prolagns dot co dot kr Assigned: jah (profile)
Status: Closed Package: DBM/DBA related
PHP Version: 3.0.12 OS: Solrais6.0
Private report: No CVE-ID: None
 [1999-09-29 21:46 UTC] kangkw at prolagns dot co dot kr
Hello, PHP Developer.
My name's ku-won Kang.
This is the south Korea.

I can't english very well.

So, I have a one problem that is not correspond to the result of a row when after executed 'ifx_affected_rows'.
For exmaple, In this sql statements "select nickname from addressbook where id  = 'kangkw';", table of the 'addressbook' has 4 rows about name of the 'id'. but result of the 'ifx_affected_rows' has only 2 rows. That is same in an other case it's if name of id has 3, 4, 5, anything.
If you possible about the problem, I'll wait for your help as soon as possible.

Thank you. 
Sincerely yours.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-10-03 23:22 UTC] jah at cvs dot php dot net
The documentation for ifx_affected_rows clearly says:

"For inserts, updates and deletes the number is the real number (sqlerrd[2])
of affected rows. For selects it is an estimate (sqlerrd[0]). Don't rely on it."

This is, if I remember it right, because Informix creates the estimate and starts
returning results as fast as it can, before actually fully completing the query.

 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Thu Nov 26 16:01:23 2020 UTC