ok I found a blurb on it in the book. But I am not sure what how to use it.
> -----Original Message----- > From: Kotha, Nagaraju [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 23, 2001 2:16 PM > To: 'Kipp, James'; [EMAIL PROTECTED] > Subject: RE: Inserting Multiple values > > > use prepare_cached() function > > --Raju > > > -----Original Message----- > From: Kipp, James [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 23, 2001 11:09 AM > To: [EMAIL PROTECTED] > Subject: Inserting Multiple values > > > Hello > > I am quite new to DBI and I am learning from the Perl DBI > Book. It does not > cover inserting data in detail. I am just wondering the best > way to insert > many values into a field. I know it is something like: > > $dbh->prepare( "INSERT INTO tbl_people ( lastname ) VALUES (?)" ); > > How do I have it iterate through an array of names ? > > foreach $name (qw( Smith Jones Roberts Johsnon Fredericks) ) { > sth->execute($name); > } > > Thank You > >
