Stacy Mader wrote:
>
> $allocated_to = $dbh->quote('NULL');
That's wrong for two reasons: don't use quote() on something that
already has quotes around it unless you want the literal quotes in the
string; and if you mean an actual SQL NULL, it should not be quoted by
either method.
> Can the $dbh->do quote my values automatically?
Yes, with placeholders:
$dbh->do(
" INSERT INTO $fault_db VALUES (?,?,?,?,?,?,?,?) ", undef,
$reported_by, $project, undef, $one_line_summary, $issue,
'Y', undef, 'NOT YET ALLOCATED'
);
Note the use of the first undef which is a stand-in for \%attr which you
don't need. The following undefs (with no quotes around them) are for
SQL NULLs.
--
Jeff
