ID: 13020
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: InterBase related
Operating System: Windows 2000
PHP Version: 4.0.6
New Comment:
Hi,
I installed PHP 4.12 and in my script replaced the call to
ibase_query(...) with the call to ibase_prepare(...) and
ibase_execute(...). It seems to me the error has gone.
It makes some sense to me. The problem thus seems to be
ibase_query(...) somehow stores the result wrong(ly).
I keep testing.
Regards
Bernhard
Previous Comments:
------------------------------------------------------------------------
[2002-01-08 07:58:51] [EMAIL PROTECTED]
--- [EMAIL PROTECTED] ---
This is an addendum to bug 13020.
I experience this bug in all versions above 4.0.4 with Windows NT 4 and
Windows 2000 using
Microsoft Internet Information Service 4 respective 5.
The eroor occurs on a repeated call to an ibase_fetch_*()-function.
The original reporter says it does not occur if he doesn't use a while
loop. This is not
because of the missing loop but because he only calls ibase_fetch_row()
or
ibase_fetch_object() once.
-----------------------
------------------------------------------------------------------------
[2001-08-29 05:41:58] [EMAIL PROTECTED]
Hi there, thanks for reading this.
I am running php4.0.6 under windows 2000, apache 1.3.x and as database
I am using Interbase 6.0
Php is running perfectly.
The problem is when trying to read data in a while statement from the
database. In particular i have written :
$dbh = ibase_connect ($hostname, $DBUsername, $DBPassword);
$stmt = "SELECT * FROM links";
$sth = ibase_query ($dbh, $stmt);
while ($row = ibase_fetch_object ($sth) ) //problem here
{
echo $row->L_NAME;
}
ibase_close ($dbh);
Up to the while statement everything is fine. The connection is set
correctly and the query is ran.
The problem is when i say : while ($row = ibase_fetch_object ($sth) )
After the execution of that line i get :
Application error. Click ok to close, cancel to debug.
The interesting thing is that if i dont use a while but :
$row = ibase_fetch_object ($sth) ;
echo $row->L_NAME;
it works fine.
I tried ibase_fetch_row and get the same error.
I would be very grateful if you could advise me on the matter.
Thank you very much.
Leon
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=13020&edit=1
