If you stop at
my @question_marks = ('?') x @column_names; #Thx [Zaxo]
you're going to generate unhappy queries. Try something like
my $question_marks = join(',', ('?') x @column_names);
You could try to remember do local $" = ','; before interpolating @question_marks, but that seems to me to be an uneccessary, error-prone step.
You are, of course, correct. I have been setting $" locally to deal with that problem. Thanks for the tip, I'll definitely use it. Peace, jg _____________________________________________________ Think a race on a horse on a ball with a fish! TG
A scheme that requires that for the thing you did over here to work, you also need to do something over there is problematic. In computer sciency terms, you've introduced a form of "coupling". (Remember the mantra "Cohesion is good, coupling is bad.")
One risk is that someone will copy/paste from your solution, pick up @questions_marks, neglect to also copy the change to $", and then wonder why what works for you doesn't work for them (and then burn up their coworkers' time (and then post to PM)).