in reply to Re: DBI Conundrum Using CGI::App
in thread DBI Conundrum Using CGI::App

$dbh->commit? Oh, yes. But before I'd do a $sth->finish.

--shmem

_($_=" "x(1<<5)."?\n".q·/)Oo.  G°\        /
                              /\_¯/(q    /
----------------------------  \__(m.====·.(_("always off the crowd"))."·
");sub _{s./.($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e.e && print}

Replies are listed 'Best First'.
Re^3: DBI Conundrum Using CGI::App
by Hue-Bond (Priest) on Jul 06, 2006 at 20:05 UTC

    Quoting the DBI documentation:

    • rarely needed
    • frequently overused
    • you should not normally need to call it explicitly
    • internal "housekeeping" method that is rarely needed

    And I don't see why it should be used here.

    --
    David Serrano

Re^3: DBI Conundrum Using CGI::App
by jZed (Prior) on Jul 06, 2006 at 20:03 UTC
    $sth->finish() is relevant only to SELECT and other data-returning calls and only then when the data has not been fully fetched. It has no relevance to an UPDATE statement and should *not* be used in this case.