in reply to DBI placeholders, bind_values, and SQL_DATE

Assuming 'Now()' is a MySQL function, this is one place NOT to use placeholders, replace the corresponding '?' with 'Now()' and remove it from your @values list. Unless you want to get localtime() and reformat it for MySQL, you'll need to create another statement handle if you want to insert something besides Now().

If on the other hand, Now() is a function in your perl program, remove the quotes around it in your @values assignment.

  • Comment on Re: DBI placeholders, bind_values, and SQL_DATE