Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re^2: SQLite UPDATE table lock

by packetstormer (Monk)
on Jul 23, 2012 at 14:01 UTC ( #983175=note: print w/ replies, xml ) Need Help??


in reply to Re: SQLite UPDATE table lock
in thread SQLite UPDATE table lock

Thanks for the suggestion. Placing the $sth->finish before the update call worked. I should have had COUNT(*) too (that was a typo) so a fetchrow()worked in that instance.
Thanks


Comment on Re^2: SQLite UPDATE table lock
Select or Download Code
Re^3: SQLite UPDATE table lock
by mje (Curate) on Jul 23, 2012 at 16:03 UTC

    If you change to select count(*) and call fetchall* you should not need to call finish. Generally speaking, if you are calling finish it should be an indication that you /might/ be doing something wrong.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2015-07-06 10:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (71 votes), past polls