Re: Interbase 5.6 error and php 4.0.4

I have reconstructed the code to: <? require("qc.inc"); $conn = ibase_connect($host,$user,$pwd); $sql = "select * from manufacturer"; $qry = ibase_prepare($conn,$sql); $rslt = ibase_execute($qry); $rcd = ibase_fetch_object($rslt); echo $rcd->AIRWAY_BILL; ?> and I get the following errors: Warning: InterBase: Dynamic SQL Error SQL error code = -901 feature is not supported in /home/www/secure/qctest.php on line 4 Warning: Supplied argument is not a valid InterBase query resource in /home/www/secure/qctest.php on line 5 Warning: Supplied argument is not a valid InterBase result resource in /home/www/secure/qctest.php on line 6 It seems that the ibase_query and ibase_prepare might be failing because of the returned value of $conn which is "'Resource id #1"...? ----- Original Message ----- From: "Miles Thompson" <milesthompson@sprint.ca> To: "Greg Kelley" <gkelley@londavia.com>; <php-db@lists.php.net> Sent: January 03, 2001 7:58 AM Subject: Re: [PHP-DB] Interbase 5.6 error and php 4.0.4 > Did you check the docs? Your code looks right, but at > http://www.php.net/manual/function.ibase-query.php the bottom > line is that > ibase_query() doesn't work. Apparently it's a two-step process, > ibase_prepare() and ibase_execute(). > > Please try it again using that construct and let us know. > > Regards - Miles Thompson > > > At 07:44 AM 01/03/2001 -0500, you wrote: > >I just upgraded to 4.0.4 from 4.0.2 and decided to try to access our > >Interbase Server data. Here is the code snippet: (I had not tried to > >access Interbase before the upgrade, so I don't know if 4.0.2 was working) > > > ><? > > require("qc.inc"); > > $conn = ibase_connect($host,$user,$pwd); > > echo $conn; > > $sql = "select * from manufacturer"; > > $rslt = ibase_query($conn,$sql); > > $rcd = ibase_fetch_object($rslt); > > echo $rcd->AIRWAY_BILL; > >?> > > > >qc.inc has our host, user, and pwd info. The result of $conn is 'Resource > >id #1' which seems to be a strange link id - I thought it was an integer value? > > > >The error is Warning: InterBase: Dynamic SQL Error SQL error code = -901 > >feature is not supported from the $rslt= line where the actual query is run. > > > >Any ideas regarding Interbase would be appreciated - thanks. > > > > > >________________________ > >Greg Kelley, IT Director > >Londavia, Inc. > >Pease Int'l Tradeport > >68 New Hampshire Ave. > >Portsmouth, NH 03801 > >603.766.3005 > >http://www.londavia.com > >SSA, EAA, AOPA, N5506M > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >