#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 have found no sql.log file on this webserver. Any comments or suggestion? Previous Comments: ------------------------------------------------------------------------ [2002-09-26 10:47:30] kalowsky@php.net can you please make a sql log file and post the results of this? It would make debugging this a lot easier :) ------------------------------------------------------------------------ [2002-09-26 10:32:59] scott@abcoa.com I found one interesting observation when I write a short test script. It showed that if I use the odbc_fetch_row() only, it work fine. It showed that if I use the odbc_fetch_into() only, it work fine. It showed that if I use both the odbc_fetch_row() and odbc_fetch_into(), it showed a minor problem, that is not being able to display one row if there is only one row. But work fine when there's two rows or more. ------------------------------------------------------------------------ [2002-09-23 08:41:14] scott@abcoa.com Forget the last comment I made, I typed down the wrong function, so use this comment instead of hte last comment. Should have read it once more time to make sure I don't overlook something. ----------------------------------------------------------- The webserver is made of IBM RS/6000, use IBM AIX and use IBM DB2 for database. The odbc_fetch_into() worked fine. To test it the functionality of the odbc_fetch_row(), I do the echo command followed by 'Result or No Result??? -->' then the odbc_fetch_row(). This tell me whether the result is returned in form of data or not. So, this showed the problem lie with odbc_fetch_row(). Because when there is two rows, it work okay and allow the odbc_fetch_into() to show two rows. When I delete one row, the odbc_fetch_row() saw one row and it does not allow the odbc_fetch_into() to show the one row. ------------------------------------------------------------------------ [2002-09-23 08:39:07] scott@abcoa.com The webserver is made of IBM RS/6000, use IBM AIX and use IBM DB2 for database. The odbc_fetch_into() worked fine. To test it the functionality of the odbc_fetch_row(), I do the echo command followed by 'Result or No Result??? -->' then the odbc_fetch_row(). This tell me whether the result is returned in form of data or not. So, this showed the problem lie with odbc_fetch_into(). Because when there is two rows, it work okay and allow the odbc_fetch_into() to show two rows. When I delete one row, the odbc_fetch_row() saw one row and it does not allow the odbc_fetch_into() to show the one row. ------------------------------------------------------------------------ [2002-09-22 20:00:43] kalowsky@php.net Considering the code in question hasn't changed since 4.0.5, I don't think this is a bug in PHP. Regardless what ODBC driver, and DB are you connecting to? And are you sure you're not refering to odbc_fetch_into? Because that prototype did change... ------------------------------------------------------------------------ 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