ID: 16523 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Feedback Bug Type: InterBase related Operating System: linux (2.4.18, slackware 8) PHP Version: 4.1.2 New Comment:
May you upgrade your interbase.c with that one in RC2 at www.php.net/~derick ? and ... have you already look at http://www.php.net/manual/en/function.ibase-connect.php there is an example showing how to loop in a resultset Daniela Previous Comments: ------------------------------------------------------------------------ [2002-04-10 10:50:38] [EMAIL PROTECTED] sure =) here are links to: #the test, working (no returned value from function being assigned to variable) both in working form and in viewable form: http://www.csmaster.org/art/initial_test.php http://www.csmaster.org/art/initial_test.phps #same script, with the line uncommented (attempt to store the returned value from ibase_query()) http://www.csmaster.org/art/initial_fail.php http://www.csmaster.org/art/initial_fail.phps #still available, server info http://www.csmaster.org/test.php you're welcome to connect to the database as shown, the firebird server should be accessible from the outside (and i just made a copy in case someone gets fancy.) i know there's a lot of junk in those, but we spent a few hours trying various things, which all sorta wound up in the same file, to get it to let us do simple queries. it's my first time using php, but not firebird. ------------------------------------------------------------------------ [2002-04-10 05:41:42] [EMAIL PROTECTED] I cannot reproduce it. Could you provide a little test script, please? ------------------------------------------------------------------------ [2002-04-10 01:16:34] [EMAIL PROTECTED] // successful: $stuff = ibase_fetch_row (ibase_query($sql_string)); # we can get $stuff[0], rows are being returned // not successful: $thingie = ibase_query($sql_string); # same statement, same file -- won't work. # if we comment this line out, the one above will work. # if this line does get executed, it fails. we can, for # that matter, grab the returned value and echo it! but # if for the life of us we try to assign it -into- a # variable so we can call ibase_fetch_row multiple times # (kinda handy) the script won't run. // i'm not the sysadmin, but i'll try to get any info that would help out. we're talking to Firebird 1.0 (which supports all of Interbase 6.0's communications protocols) and i've not had any problems with the interbase->firebird conversion in other situations. also tested: ibase_prepare gives us the same problem. if the return value is encapsulated in the call to ibase_execute, the script doesn't crash. if we grab it into a variable, and try to use that variable for the ibase_execute call, we don't ever get that far (the assignment kills it.) i've checked for the often-mentioned patch to interbase.c, we have it. http://www.csmaster.org/test.php for info on our server (in case you wanna know) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16523&edit=1