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.

Reply via email to