>FYI -
>Be careful using dbh->quote with inserts and updates. If you feed dbh->quote a
>variable that has
>no value, it will return '' (tick tick). If the column is a date the
>value will
>be set to 0000-00-00 and
>if the column is numeric it will be set to 0 instead of NULL . You can either
>check the length of the variable to see if you
>can quote it, or use a sub_routine like below and call it instead
>of dbh->quote.
That is false. If you feed $dbh->quote() an *empty string*, it will
do what you suggest. If you feed it undef, quote() will return the word
NULL with no surrounding quotes. In both cases, quote() is doing the
correct thing.
sql,query
