my $update_table1=$dbh1->prepare("
UPDATE table1
SET retrieval_date=?
WHERE idnum=?
");
$sth->execute($result,$file);
And if that is what you want, take the prepare statement out of the loop. Do the prepare once at the top and then the execute repeatedly inside the loop.
-- Jeff
