Hi all,
I have the following:
$reported_by = $dbh->quote($reported_by);
$project_no = $dbh->quote($project);
$project_comments = $dbh->quote('NULL');
$one_line_summary = $dbh->quote($one_line_summary);
$issue = $dbh->quote($issue);
$new_report = $dbh->quote('Y');
$allocated_to = $dbh->quote('NULL');
$fix_status = $dbh->quote('NOT YET ALLOCATED');
$dbh->do(qq{
INSERT INTO $fault_db
VALUES ($fault_no,
$reported_by,
$project_no,
$project_comments,
$date_occurred,
$date_reported,
$time_lost,
$one_line_summary,
$issue,
$new_report,
$allocated_to,
$fix_status
)
});
Can the $dbh->do quote my values automatically? ie, do I
specifically need to call $dbh->quote on every value before
I perform the DO statement? I'm using DBI v1.20 with Oracle
7.3.3
Thanks in advance,
Regards,
Stacy Mader.