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?
--K
--
Ken Speich
Manager, Network Surveillance Tools
[EMAIL PROTECTED] 301-598-0500 x2637
"How can you shoot the devil in the back? What if you miss?"
