ID: 19528
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: ODBC related
Operating System: AIX (UNIX)
PHP Version: 4.2.2
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2002-09-26 10:57:50] [EMAIL PROTECTED]
I have found no sql.log file on this webserver. Any comments or
suggestion?
------------------------------------------------------------------------
[2002-09-26 10:47:30] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
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
