Re: Bug #949: informix function bug! => ifx_affected_rows

hay, youngtk@www.dm.co.kr wrote: > > From: youngtk@www.dm.co.kr > 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@test","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@idgruppe.com christian@cartus.com ICQ-Mail: 964898@pager.mirabilis.com ICQ-UIN: 964898 -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net