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.