FWIW: This is the solution that I finally settled upon (in full context):
$column_names = "COMPANY_NAME,JOB_TITLE,JOB_ID,URL,MAIL_TO,ATTACH,DATE";
foreach (qw(company_name job_title job_id url mail_to attach)), time) {
# Append the quote'd parameter-value || the time-value in the list
$new_values .= $dbh->quote(param($_) || $_) . ',';
}
# Remove the final comma from $new_values
chop $new_values;
$sth = $dbh->do("INSERT INTO $db_file ($column_names) VALUES ($new_values)")
or die "Could not prepare statement: " . DBI->errstr;
--
Eric P.
Los Gatos, CA
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
