Re: Active statement error

2001-05-31 Thread Tim Bunce
On Thu, May 31, 2001 at 01:44:37PM +0200, Bart Lateur wrote: > On Thu, 31 May 2001 19:29:12 +0800 (PHT), Orlando Andico wrote: > > >On Thu, 31 May 2001, [iso-8859-1] Hèctor Alòs i Font wrote: > >.. > >> Simply something as simple as : > >> > >> $sth = $dbh->prepare ("select FIELD from TABLE wher

Re: Active statement error

2001-05-31 Thread Bart Lateur
On Thu, 31 May 2001 19:29:12 +0800 (PHT), Orlando Andico wrote: >On Thu, 31 May 2001, [iso-8859-1] Hèctor Alòs i Font wrote: >.. >> Simply something as simple as : >> >> $sth = $dbh->prepare ("select FIELD from TABLE where >> IDENTIFIER=?"); >> $sth->execute ('VALUE'); >> ($field_value) = $sth->

RE: Active statement error

2001-05-31 Thread Neil Lunn
Thursday, May 31, 2001 9:27 PM > To: Bart Lateur > Cc: [EMAIL PROTECTED] > Subject: Re: Active statement error > > > Simply something as simple as : > > $sth = $dbh->prepare ("select FIELD from TABLE where > IDENTIFIER=?"); > $sth->execute ('VAL

Re: Active statement error

2001-05-31 Thread Orlando Andico
On Thu, 31 May 2001, [iso-8859-1] Hèctor Alòs i Font wrote: .. > Simply something as simple as : > > $sth = $dbh->prepare ("select FIELD from TABLE where > IDENTIFIER=?"); > $sth->execute ('VALUE'); > ($field_value) = $sth->fetchrow_array; Make sure to do an $sth->finish; before quitting. This

Re: Active statement error

2001-05-31 Thread Hèctor Alòs i Font
Simply something as simple as : $sth = $dbh->prepare ("select FIELD from TABLE where IDENTIFIER=?"); $sth->execute ('VALUE'); ($field_value) = $sth->fetchrow_array; En/Na Bart Lateur ha escrit: > On Thu, 31 May 2001 13:06:26 +0200, Hèctor Alòs i Font wrote: > > >DBI::db=HASH(0xfa5dc)->disconne

Re: Active statement error

2001-05-31 Thread Michael A. Chase
mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Hèctor Alòs i Font" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 04:06 Subject: Activ

Re: Active statement error

2001-05-31 Thread Bart Lateur
On Thu, 31 May 2001 13:06:26 +0200, Hèctor Alòs i Font wrote: >DBI::db=HASH(0xfa5dc)->disconnect invalidates 1 active >statement handle (either destroy statement handles or call >finish on them before disconnecting) at ... > >We are quite amazed because we can not discover which >statement handle

Active statement error

2001-05-31 Thread Hèctor Alòs i Font
We have got the following error: DBI::db=HASH(0xfa5dc)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at ... We are quite amazed because we can not discover which statement handle can be active: we just added a sel