in reply to Updating my database...or not

Indeed, you should throw out all the routines you use for quoting the data and either use placeholders or the DBI quote-method.

Or even better, for composing your SQL-statements, think of using SQL::Abstract or go all the way and use DBIx::Class.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

In Section Seekers of Perl Wisdom