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... if I execute it again, does the new
> dataset just overrun the old one?
>
finish() just ends the current occurence of execute(). You can
execute() again after a finish().
However, you only need to call finish() for a SELECT, and only if you're
going to stop calling fetch...() before you've fetched all the results.
Otherwise, the finish() is done implicitly.
Ronald
