> > > On Mon, 18 Nov 2002 11:11:47 -0800 (PST), Michael A Chase wrote: > > >I'm not sure about Access, but some underlying databases don't like > >multiple statements open at the same time on a single database handle. > >Just for testing, try opening separate database connections for each > >statement and see if that helps. > > > ># For example (untested): > >$sth_a = $dbh_a -> prepare( $sql_a ); > >$sth_b = $dbh_b -> prepare( $sql_b ); > > If that helps, I would cache the SQL strings, not the statement handles, > and use just one $dbh.
It shouldn't matter, though, as, from looking at how he's using it, the implicit finish should be called, thus only one statement at a time would be running. Regards, Jeff ============================================= See the DBI FAQ at www.xmlproj.com/cgi/fom.cgi
