Re: [PHP-DEV] Bug #949: informix function bug! => ifx_affected_rows From: Christian Cartus (chc <email protected>)
Date: 11/25/98

hay,

youngtk <email protected> wrote:
>
> From: youngtk <email protected>
> Operating system: AIX 4.2.1
> PHP version: 3.0.5
> PHP Bug Type: Other
> Bug description: informix function bug! =&gt; ifx_affected_rows
>
> Here is my source ...
>
> <?php
>
> $conn = ifx_connect("stores7 <email protected>","informix","test");
> $query = "SELECT * FROM customers";
>
> $rid = ifx_query($query,$conn);
> $rowcount = ifx_affected_rows($rid);
>
> echo $rowcount;
>
> ?>
>
> The value of $rowcount is 1! Why? The real row count is 150!
>
> My Configuration is ...
>
> configure --prefix=/home --with-apache=/home/tmp/apache_1.3.3 --with-gd=no --with-mysql=/home/mysql --with-informix=/usr/inf --with-imap=/home --with-config-file-path=/home/etc --with-exec-dir=/home/libexec --enable-track-vars=yes --enable-memory-limit=yes
>
this is not a bug (hope so). esql/c returns only the astimated rows. the
best way to avoid that esql/c-feature is to move the cursor to the last
postition of the rows and then call the ifx_affected_rows-funktion.

chris 

-- 
Christian Cartus                    I-D Media GmbH & Co. KG
Tel. +49-7365/960543                       Dewanger Str. 22
     +49-177/7644933                   73457 Essingen-Forst
Fax: +49-7365/5060         
E-Mail: chris.cartus <email protected>      christian <email protected>
ICQ-Mail: 964898 <email protected>        ICQ-UIN: 964898

--
PHP Development Mailing List   http://www.php.net/
To unsubscribe send an empty message to php-dev-unsubscribe <email protected>
For help: php-dev-help <email protected>