in reply to Class::DBI and data split multiple tables

If you have the ability to, you could consider putting together a view that combines all of the transaction tables into one and write a Class::DBI class for that view instead of the individual tables.
split//,q{john hurl, pest caretaker}and(map{print @_[$_]}(join(q{},map +{sprintf(qq{%010u},$_)}(2**2*307*4993,5*101*641*5261,7*59*79*36997,13 +*17*71*45131,3**2*67*89*167*181))=~/\d{2}/g));

Replies are listed 'Best First'.
Re^2: Class::DBI and data split multiple tables
by kor (Initiate) on Mar 20, 2007 at 20:03 UTC
    Hmmm I could possibly yes, that might get pretty ugly on the view I'll have to think about it thanks.