I agree !
> -----Original Message-----
> From: Hardy Merrill [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 2:31 PM
> To: Kipp, James
> Cc: [EMAIL PROTECTED]
> Subject: Re: Inserting Multiple values
>
>
> The prepare_cached() is not necessary to get your code to work -
> I'd leave that for later.
>
> Kipp, James [[EMAIL PROTECTED]] wrote:
> > 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
> > >
> > >
>
> --
> Hardy Merrill
> Mission Critical Linux, Inc.
> http://www.missioncriticallinux.com
>
