I've seen this with MS SQL connections. What it boils down to is that the data type that is returned isn't understood, the extension dies, and nothing is returned. Try a simpler select statement (I know its hard to go much simpler but.... ;-) - go for "select 'hello world'". And then try giving the column a name - it could be that. "select 'hello world' as HiWorld" - (the "as" is optional, I can't remember whether interbase wants it or not).
If you can work out what sql statements don't work, then mail the list back and I'll have a look at the extension. Dave. > -----Original Message----- > From: Todd Cary [mailto:[EMAIL PROTECTED]] > Sent: 07 January 2002 19:29 > To: [EMAIL PROTECTED] > Subject: [PHP] PHP 4.4.1 and Interbase > > > I am running PHP 4.1.1 on RH Linux 7.2 with Apache and I am getting an > error as soon as I try to execute the query. The browser error with > Netscape is "Document contains no data. Try again later..." > > echo('Opening Interbase<br>'); > $dbh = db_open($host,$user,$password); > if ($dbh) { > > $stmnt = 'SELECT COUNT(*) FROM PHOTOS'; > $sthdl = ibase_query($stmnt,$dbh); > if ($sthdl) { > echo('Query succeeded<br>'); > } else { > echo('Cannot perform query<br>'); > } > > echo('Closing Interbase<br>'); > ibase_close($dbh); > } else { > echo('Could not open Interbase!<br>'); > } > > If I comment out > > $stmnt = 'SELECT COUNT(*) FROM PHOTOS'; > > All run fine. Also, this piece of code use to work. Any suggestions? > > Todd > -- > Todd Cary > Ariste Software > [EMAIL PROTECTED] > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
