On Fri, May 04, 2001 at 03:26:40PM -0700, SELVARAJAN,DANESH K (Non-HP-PaloAlto,ex1)
wrote:
> Hi Tim,
>
> $sth->finish
>
> This Indicates that no more data will be fetched from this statement before
> it is either prepared again or destroyed and to allow the server to free up
rds
> >
> > Dan.
> >
> >
> >
> > -Original Message-----
> > From: Tim Bunce [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 04, 2001 2:42 PM
> > To: Ken Speich
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Prepare/Finish ques
- Original Message -
From: SELVARAJAN,DANESH K (Non-HP-PaloAlto,ex1)
<[EMAIL PROTECTED]>
To: 'Tim Bunce' <[EMAIL PROTECTED]>; Ken Speich <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 12:26 AM
Subject: RE: Prepare/Finish questi
4, 2001 2:42 PM
To: Ken Speich
Cc: [EMAIL PROTECTED]
Subject: Re: Prepare/Finish question
On Fri, May 04, 2001 at 01:59:05PM -0400, Ken Speich wrote:
> Does a $sth->finish; close out a $dbh->prepare()?
>
> For example, if I do the following:
>
> $sql = "select sysdate fro
On Fri, May 04, 2001 at 01:59:05PM -0400, Ken Speich wrote:
> Does a $sth->finish; close out a $dbh->prepare()?
>
> For example, if I do the following:
>
> $sql = "select sysdate from dual";
> $sth = $dbh->prepare($sql);
>
> while(1) {
> $sth->execute
>
> (Do some stuff here)
>
>
On Fri, May 04, 2001 at 01:59:05PM -0400, Ken Speich wrote:
> Does a $sth->finish; close out a $dbh->prepare()?
> Does $sth->finish make the query go away? Do I even wanna put that in
> there? I want the prepared statement to stick around, because I am going
> to be running it indefinitely... i
Does a $sth->finish; close out a $dbh->prepare()?
For example, if I do the following:
$sql = "select sysdate from dual";
$sth = $dbh->prepare($sql);
while(1) {
$sth->execute
(Do some stuff here)
$sth->finish
}
Does $sth->finish make the query go away? Do I even wann