I am on the very last step of my Perl script.
Congrats!
$sql_cmd = "\"UPDATE Chunkmail SET Contribute_flag=1 WHERE Chunkmail_ID=" . @contribute_flag[$_] . "\""; $rslt = $dbh->do($sql_cmd);
Try:
$sql_cmd = q{
UPDATE Chunkmail SET Contribute_flag=1 WHERE Chunkmail_ID=?
};
$rslt = $dbh->prepare( $sql_cmd );
$rslt->execute( $contribute_flag[$_] );Your quote marks were messing you up and the easiest way to avoid that and other problems is to use placeholders (the ? in the $sql_dmd).
-- Jeff
