RE: [PHP] PHP 4.4.1 and Interbase

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:todd@aristesoftware.com] > Sent: 07 January 2002 19:29 > To: php-general@lists.php.net > 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 > todd@aristesoftware.com > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >