Re: DBI and Inserting an Array

[krujos]

in reply to DBI and Inserting an Array

I was able to do it using the following.

my $sth = $dbh->prepare("INSERT INTO $table ($cols) VALUES (?,?,?)")
   or die "$dbh->errstr";
my @array=('one', 'two', 'thee');
$sth->execute(@array) or die "$dbh->errstr : $table";

You should be able to plug your code in pretty easily.

[carric]

Excellent. Thanks guys. That did the trick!! =)