in reply to DBI Multidimensional array

This node falls below the community's minimum standard of quality and will not be displayed.

Replies are listed 'Best First'.
Re: Re: DBI Multidimensional array
by perlplexer (Hermit) on Apr 24, 2002 at 12:44 UTC
    No, please don't do it that way.
    1. You are quoting the values yourself
    2. You are using do() instead of prepare() and execute() 
    # assuming data is in @array
my $sth = $dbh->prepare('INSERT INTO foo (bar, baz) VALUES (?, ?)');
$sth->execute(@$_) for (@array);

    [download]
    --perlplexer
[reply]
[d/l]
    A reply falls below the community's threshold of quality. You may see it by logging in.

In Section Seekers of Perl Wisdom