Re: 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