Can anyone here advise me the best way to have two classes access mysql
via a third Mysql DB statements class?
example of what I’m trying to do is below.
I am sure I need to use a pool of connections but am unsure as to how
best to do this.
EVERYTHING works except for this issue.
@db = Mysqlclass.new ## this connection is the 1st link!
@db =Mysqlclass.new ## 2nd connection and get a error relating to
@dbh = DBI.connect( … )
@dbh.select_all(‘select * from a table’)
Other queries etc below here
I can get things to work if I change the 2nd script to a method but then
I hit other issues here so would be much happier have multiple
I’ve trolled but not found anything that shows me how to do this using
I’d sort of expect to have found something like a method or parameter to
DBI.connect(localhost,…,connections <number wanted)
DBI.connection = 1 can change to 20
any help be grateful.