in reply to DB update query from Linux using a Hash array
Another way to test this is to change your UPDATE statement into an INSERT statement (just change the WHERE to a comma.) If the INSERT statement works, that would indicate the UPDATE statement is not working because it is not satisfying the WHERE clause.
Finally, I would suggest you read up on using place-holders. They will save you a lot of trouble with constructing SQL statements. Re-written to use place-holders, your loop would become:
This is also a bit more efficient as the SQL statement is only prepared once.my $update = $ldb->prepare("UPDATE LOW_PRIORITY $ldbtable SET $mtime=? + WHERE software=?"); foreach my $key1 ( keys %prog_numbers) ) { $update->execute($prog_numbers{$key1}, $key1); }
|
|---|