>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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
