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)
>
> $sth->finish
> }
>
>
> 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... if I execute it again, does the new
> dataset just overrun the old one?
Is the manual unclear?
Tim.