Not yet :) DBI just added specs to handle that and DBD::ODBC will, in the future, do that.
Patches welcome, as I don't have time in the next few weeks. Jeff > -----Original Message----- > From: Snethen, Jeff [mailto:[EMAIL PROTECTED]] > Sent: Friday, May 24, 2002 1:52 PM > To: [EMAIL PROTECTED] > Subject: Multiple INSERTS > > > I'm using ODBC to connect to a M$ Access DB and I have a case > where I'm having to insert a large number of rows. My > subroutine that accomplishes this is: > > sub updateCodeProfile > { > my ($self, @args) = @_; > > $self->{_sth}->{_CodeProfileTbl}->execute( $self->{_dateID}, @args ); > } > > where my connect and prepare are done at construction time, so > that is out of the picture. I simple call > "updateCodeProfile" with my data about 9000 times to insert each > row. What I was wondering was if there was something > like the fetchall_arrayref() except for the > execute--executeall_arrayref()--where I could just feed it a list and it > will keep executing that list until it is finished? I don't > recall seeing anything like that in my book. > > Thanks. > Jeff >
