Re: Re: inserting in a database

Replies are listed 'Best First'.
3Re: inserting in a database by jeffa (Bishop) on Nov 25, 2003 at 13:20 UTC
... 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)	[reply] [d/l] [select]

Replies are listed 'Best First'.

3Re: inserting in a database
by jeffa (Bishop) on Nov 25, 2003 at 13:20 UTC

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

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

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

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)