Howdy group!

perldoc DBI
has this:
   $rv  = $dbh->do($statement, \%attr, @bind_values);

So would this be a proper use of it:

 $dbh->do(
   'INSERT INTO Stuff (Id,Foo) VALUES (NULL,?)',
    undef,
    qw('foo' 'bar' 'baz')
 ) or die ....
# IE undef foro \%attr and include quoted data

That would essencially run:
 INSERT INTO Stuff (Id,Foo) VALUES (NULL,'foo');
 INSERT INTO Stuff (Id,Foo) VALUES (NULL,'bar');
 INSERT INTO Stuff (Id,Foo) VALUES (NULL,'baz');
since do() does the prepare and execute for you.
correct?

TIA

Lee.M - JupiterHost.Net

Reply via email to