3Re: inserting in a database

... or use place holders instead:

my $sth = $dbh->prepare("
   INSERT INTO dd 
   VALUES(?,?)
");

$sth->execute($identifier[$eu],'Feature');
[download]

and let the module do intelligent quoting and provide statement caching for you (like hmerrill provided). Kudos to Taulmarill, however, for using

for my $eu (0..$#identifier) {
[download]

instead of

for (my $eu = 0; $eu <= (scalar(@identifier)); $eu++) {
[download]

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Comment on 3Re: inserting in a database Select or Download Code