Original OP - how about some more info? Copy and paste in the errors that you are getting.
Hardy Merrill >>> "Jenda Krynicky" <[EMAIL PROTECTED]> 08/25/04 01:47PM >>> From: "Registry" <[EMAIL PROTECTED]> > I hope I am addressing this question to a correct email. > > I am trying to make multiple prepare statements on one database > connection, however I am getting errors. > I would just like to know if this is possible. The logic goes > something like: > > my $DBH = DBI->connect(); > my $sth = $DBH->prepare( SELECT ...); > my $rv = $sth->execute(); > > my $sth2 = $DBH->prepare( SELECT ...); > my $rv2 = $sth2->execute(); > > Thank you in advance. Yes it should be possible. But some drivers require that you first read the whole resultset before you try to prepare or execute another statement. Jenda ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery
