Subject Re: [ib-support] php...invalid statement handle
Author Surojit Niyogi
Helen,

Thanks for your response. The code I'm using in one case of this error is
shown below:

$objConn = ibase_connect(DBHOST, DBUSERNAME, DBPASSWORD);
$strSQL = "SELECT Header,MessageText FROM Notification WHERE
NotificationID=" . requestquerystring("notNum");
$objRec = ibase_query ($objConn, $strSQL);

In this case, I'm actually opening a SELECT statement so I have no clue why
it would be complaining.

-Surojit

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, July 06, 2001 8:55 PM
Subject: Re: [ib-support] php...invalid statement handle


> At 05:46 PM 06-07-01 -0500, you wrote:
> >I'm getting the following error on *some* of my connections to Interbase
from PHP. I have no idea why. It says the following:
> >
> > Warning: InterBase: invalid statement handle in ...
> >
> >Anybody ever come across this kind of error?
>
> Yes, it crops up when your application tries to "open" a statement that is
not a SELECT statement - such statements have to be executed.
>
> Regards,
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative ยท http://www.interbase2000.org
> _______________________________________________________
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>