As I said in my write up there is a lot more that can be done with the code that I presented. For instance, how about having just one DBH for the module as a whole? This way the first instantiation of an object declared in the .PM would make a connection and that connection would be used until nobody cared any more.

I am not always convinced that fetchrow_hashref is all that efficient. In fact in the DBI man page it says that it isn't.

One cat. Many ways to skin it and only that cat objects to how it is skinned...

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Peter L. Berghold --- Peter@Berghold.Net
"Those who fail to learn from history are condemned to repeat it."
[download]