[PHP-DB] about "PHP Warning: failed to rollback outstanding transactions!"

2001-07-05 Thread Michael Cheung
Hi; Linux 2.2.18 + oracle 8.1.7i + php 4.0.5 + oci8 I got a warning in log file. "PHP Warning: failed to rollback outstanding transactions!" I have simplify the script. it will cause the warning. function ShowError($errormsg,$dbh=false) { if($dbh!=false) OCILogOff($dbh); exit()

Re[2]: [PHP-DB] question about OCIBindByName(Resolved)

2001-05-22 Thread Michael Cheung
Thies C. Arntzen" <[EMAIL PROTECTED]> wrote: > On Tue, May 22, 2001 at 09:41:25AM +0900, Michael Cheung wrote: > > > > On Mon, 21 May 2001 16:39:05 +0200 > > "Thies C. Arntzen" <[EMAIL PROTECTED]> wrote: > > > > > On Mon, May 21, 2001 at 1

[PHP-DB] about "PHP Warning: failed to rollback outstanding transactions!"

2001-05-22 Thread Michael Cheung
Hi; Linux 2.2.18 + oracle 8.1.7i + php 4.0.5 + oci8 I got a warning in log file. "PHP Warning: failed to rollback outstanding transactions!" I have simplify the script. it will cause the warning. function ShowError($errormsg,$dbh=false) { if($dbh!=false) OCILogOff($dbh); exit()

Re[2]: [PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Michael Cheung
On Mon, 21 May 2001 16:39:05 +0200 "Thies C. Arntzen" <[EMAIL PROTECTED]> wrote: > On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote: > > Hi; > > Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface. > > > > I use the fo

[PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Michael Cheung
Hi; Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface. I use the following lines to get a result from database; But It give me result 0, it is incorrect; $sql="Select count(*) From member where email=:email"; $sth=OCIParse($dbh,$sql); OCIBindByName($sth,"email",$e

[PHP-DB] question about

2001-05-21 Thread Michael Cheung
Hi; I use the following lines to get a result from database; But It give me result 0, it is incorrect; $sql="Select count(*) From member where email=:email"; $sth=OCIParse($dbh,$sql); OCIBindByName($sth,"email",$email,64); OCIExecute($sth); OCIFetchInto($sth,$data); but when I directly u