Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: DBI Conundrum Using CGI::App

by Hue-Bond (Priest)
on Jul 06, 2006 at 19:32 UTC ( #559654=note: print w/replies, xml ) Need Help??

in reply to DBI Conundrum Using CGI::App

I can't figure out my sin of commission

Maybe you're missing a $dbh->commit.

David Serrano

Replies are listed 'Best First'.
Re^2: DBI Conundrum Using CGI::App
by waltw (Acolyte) on Jul 06, 2006 at 20:02 UTC
    Thank you, David, but with SQLite I have auto-commit.

    However, your response kicked several synapses into gear and I took a look at permissions..... I'm so red-faced! My directory was 755 and the webserver had read-only permission.

    I'm fixed and all is working as it should be.

    Pardon me for posting a non-problem!



Re^2: DBI Conundrum Using CGI::App
by shmem (Chancellor) on Jul 06, 2006 at 19:48 UTC
    $dbh->commit? Oh, yes. But before I'd do a $sth->finish.


    _($_=" "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}

      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

      $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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://559654]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (2)
As of 2023-10-02 02:08 GMT
Find Nodes?
    Voting Booth?

    No recent polls found