On Fri, Jan 03, 2003 at 03:56:52AM +0200, Boris Penchev wrote:
> Dear All,
>
> I has this fromlem when I have a lot of MySQL request. Now i do not have free time
>to explain this problem, but I give you smal
> example:
> my $sth = $dbh->prepare(qq~SELECT id, name FROM all~) || die "$DBI::errstr\n";
> $sth->execute();
> while ( my $id, $name = $sth->fetchrow_array() ) {
> my $sth2 = $dbh->prepare(qq~SELECT * FROM peopleaddress WHERE name = ?~) ||
>die "$DBI::errstr\n";
> $sth2->execute($name);
> while (..............) {
> ....................
> }
> $sth2->finish();
> }
> $sth->finish();
>
> If you do not use finish() in these situation you might have big problems.
What 'big problems', exactly? More details would be helpful
(along with a working example that demonstrates the problem).
Tim.
