ID: 13020 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: InterBase related Operating System: Windows 2000 PHP Version: 4.0.6 New Comment:
Any news on this yet? Previous Comments: ------------------------------------------------------------------------ [2002-03-21 10:14:39] [EMAIL PROTECTED] 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 ------------------------------------------------------------------------ [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