in reply to DBI ERROR

You need to do a $result = $statement_handle->finish on your statement handle, after you've finished fetching the data from it. The statement handle is what comes back from a prepare call. Look at your DBI documentation for more info -- I think the DBI FAQ covers this exact issue, in fact.

----Asim, known to some as Woodrow.

Replies are listed 'Best First'.
Re: Re: DBI ERROR
by Anonymous Monk on Apr 13, 2001 at 01:46 UTC
    I am already using finish for each my statement handler.
[reply]
      Obligatory request for code sample.

      For example, your program may have died and during cleanup, $dbh->disconnect would have caused the above message (since you didn't call finish if the program died before the statement was executed).

      I've seen this myself, and unless it's actually impeding further lines from executing, it's mostly harmless. Of course it does go against programmer nature to allow any nuisance messages that you could stop. I do believe that disconnect or a second statement handle is coming into play before your first finish.

      Obligatory request for system info:

      • Database (version)
      • DBI/DBD (version)

      We may be able to see it once we know more.

      ALL HAIL BRAK!!!

[reply]
[d/l]

In Section Seekers of Perl Wisdom