in reply to Maintaining column name and column order using DBI

I recommend you also investigate DBI's selectrow_hashref and fetchrow_hashref methods as well.

Update: Woops, didn't notice OP is already using those!

---
It's all fine and dandy until someone has to look at the code.

In Section Seekers of Perl Wisdom