#19528 [Fbk->Opn]: odbc_function_row() doesn't returned true if there is one row only

ID: 19528 User updated by: scott@abcoa.com Reported By: scott@abcoa.com -Status: Feedback +Status: Open Bug Type: ODBC related Operating System: AIX (UNIX) PHP Version: 4.2.2 New Comment: I looked at few IBM books and IBM website and could find no such documentation about sql.log. I also tried typing in the command "find . -name '*log' -print" and got a few IBM DB2 logs but they aren't related to sql.log. Right now, I'm out of luck. Someone else will know more about it better than I do. Previous Comments: ------------------------------------------------------------------------ [2002-09-26 15:53:58] kalowsky@php.net I'm not intimately familiar with the DB2 system, but there has to be a way to turn on ODBC logging. This is a fairly standard debugging method. Can you please check your documentation for it... it would make tracking this bug down infinately easier. ------------------------------------------------------------------------ [2002-09-26 11:56:56] scott@abcoa.com Oh! That's what it is. No, I do not use the iODBC or OpenLink or anything of that sort. There is no such as odbc.ini feature for IBM DB2. I use this configure command before compiling PHP. --clip-- ./configure --with-apache=../apache_1.3.26 --with-ibm-db2=/usr/lpp/db2_06_01 --with-openssl=../openssl-0.9.6d --with-mcrypt=../libmcrypt-2.5.2 --without-mysql --with-config-file-path=../../apache/conf --enable-track-vars --with-curl --with-xml --clip-- ------------------------------------------------------------------------ [2002-09-26 11:46:27] kalowsky@php.net Creating a sql.log is typically defined in your odbc.ini file, per DSN. You may have to alter that to turn on logging. As per the specific lines, that depends upon your vendors specific implementation. ------------------------------------------------------------------------ [2002-09-26 11:11:36] scott@abcoa.com Disregard my last comment, the bug workaround still work. I made the typo in the counter. So, that leave the original bug as unchanged. ------------------------------------------------------------------------ [2002-09-26 11:01:23] scott@abcoa.com To my dismay, I thought that including hte counter as the 2nd paramater to the odbc_fetch_row() function would fix this problem but it turned out that it doesn't. It turned out that it help a little bit but it is only an intermitted problem. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/19528 -- Edit this bug report at http://bugs.php.net/?id=19528&edit=1