Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Update is not working properly with Perl DBI Module

by tokpela (Chaplain)
on May 19, 2011 at 04:44 UTC ( #905610=note: print w/replies, xml ) Need Help??

in reply to Update is not working properly with Perl DBI Module

Two things I see (not sure if this will solve your issue):

my $update_ids = $dbh->prepare("UPDATE queue set processed = \'T\' whe +re id = $ids");

You are preparing the update statement on every while loop iteration. I think you should prepare the update statement before the while loop and use a placeholder for your id value.

my $update_ids = $dbh->prepare("UPDATE queue set processed = 'T' where + id = ?");

Also, what is the \'T\' for? 'T' should work fine since you are quoting the SQL with double quotes and don't need to escape the single quote.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (9)
As of 2016-10-24 21:32 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (310 votes). Check out past polls.