in reply to Re^4: MySQL: placeholders and NULL values
in thread MySQL: placeholders and NULL values

The OP had this: 
$cols[0] = undef ;  # gives default value of that column

[download]
which I have shown to be untrue. Doing that WILL set it to NULL.
Jeff japhy Pinyan, P.L., P.M., P.O.D, X.S.: Perl, regex, and perl hacker
How can we ever be the sold short or the cheated, we who for every service have long ago been overpaid? ~~ Meister Eckhart

In Section Seekers of Perl Wisdom