Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

Re: [PHP-DB] Interbase 5.6 error and php 4.0.4 From: Greg Kelley (gkelley <email protected>)
Date: 01/03/01

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 <email protected>>
To: "Greg Kelley" <gkelley <email protected>>; <php-db <email protected>>
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 <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>