Thank you all for your great comments. I am going to try and re-work this so it is more efficent and easier to maintain.

One other question that popped into my head was that during testing, certain variables ended up being null and caused the program to die. Is there a way to trap for that error before hand in the DBI statement without checking each var for a null? something like a try catch block in C?

Thanks again for all your great criticism!
Chris
-------------------------------
Just Your Friendly Neighborhood
_SPIDEY_