in reply to Understanding placeholders

One quick suggestion, you don't have to use DESCRIBE to retrieve the column names, you can pull the column names from your already executed statement handle like so:

my $column_names_aref = $sth->{NAME}; #or NAME_lc or NAME_uc

This way you are not dependant upon mysql specific syntax.


cp
----
"Never be afraid to try something new. Remember, amateurs built the ark. Professionals built the Titanic."