Re: updating files within the database based on dates compared

[Jeff Zucker]

A L wrote:

Okay, so, by being ignored,

Don't take that personally, all of us have asked things which didn't get 
immediate answers.  It happens.

I think what you want is:

my $update_table1=$dbh1->prepare("
   UPDATE table1
      SET retrieval_date=?
    WHERE idnum=?
");
$sth->execute($result,$file);
I could be wrong about which variables go in the execute, I didn't look 
too carefully, but I think this way of variably updating is what you are 
after.  See placeholders in the DBI documentation.
     
--
Jeff