| Subject: | DBIx::SearchBuilder::Handle to handle multiple database connections |
DBIx::SearchBuilder::Handle stores the DBI handle as a class variable,
so you can't use it to connect to more than one database; all handles
point to the database connected to last.
Tentative patch included.
cheers,
Richard.
--- Handle.pm 2003-06-11 14:14:55.000000000 +1200
+++ Handle.pm.new 2003-06-11 14:14:46.000000000 +1200
@@ -4,7 +4,7 @@
use DBI;
use strict;
use Class::ReturnValue;
-use vars qw($VERSION @ISA $DBIHandle $DEBUG $TRANSCOUNT);
+use vars qw($VERSION @ISA $DEBUG $TRANSCOUNT);
$TRANSCOUNT = 0;
@@ -265,9 +265,9 @@
my $self=shift;
#If we are setting the database handle, set it.
- $DBIHandle = shift if (@_);
+ $self->{'dbihandle'} = shift if (@_);
- return($DBIHandle);
+ return($self->{'dbihandle'});
}
# }}}