in reply to DBI won't let go!
It's possible that changing this will fix the problem. DBI could be blocking on any of those commands. You should probably include some of the error checking mentioned in the DBI documentation, and make sure you're using strict and warnings.$dbh = DBI->connect( 'Blah', 'Blah', 'Blah', 'Blah' ); # $dbh->LongReadLen( 65535 ); # since you're not fetching any data, th +is line doesn't do anything useful $stmt = $dbh->prepare( "UPDATE Images SET Name = ?" ); for(@JpgList){ $stmt->execute( $_ ); rename("$_","Processed/$_"); } $stmt->finish; $dbh->disconnect;
|
---|