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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
48 + 1 = ?
Subscribe to this entry?

 
 [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-2024 The PHP Group
All rights reserved.
Last updated: Thu Mar 28 18:01:29 2024 UTC