On Fri, 22 Nov 2002 14:21:48 -0500 (EST) Paul Boutros <[EMAIL PROTECTED]> wrote:
> Indeed, using multiple $dbh's didn't make any difference. Also, the DBI > documentation lends the impression that ->finish() shouldn't generally be > called explicitly. I have found it necessary for statements where you > know just one row will be returned (i.e. count(*)) and aren't looping > through the entire $sth. Otherwise, I thought I shouldn't be using it, > though? Too bad that multiple database handles didn't help. It was kind of a shot in the dark since I don't use ODBC or Access. Fetching a single row is one of the cases where finish() is useful. Unless you attempt to fetch a row after the last one, DBI doesn't know the statement is finished unless you tell it. In that case it thinks the handle is still active when you disconnect. -- Mac :}) ** I normally forward private questions to the appropriate mail list. ** Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html Give a hobbit a fish and he eats fish for a day. Give a hobbit a ring and he eats fish for an age.
