In the DBI module (and/or DBD::mysql), is there a way to print the completed SQL statements when you're using placeholders?
In other words, I'm using placeholders in a query and I receive this message:
DBD::mysql::st execute failed: You have an error in your SQL syntax ne
+ar 'type='1',span='2',kit='10',block='C',run='Fals' at line 1 at chan
+ge.pl line 385.
That doesn't help much for debugging purposes. I need to see the full SQL statement, but all I have in the program is
"UPDATE table SET field=?,field=?,field=? WHERE field=?". Is there a way to print the filled-in statement?
I've checked the perldoc, etc, or I wouldn't be posting here. If the answer is there, please point me to chapter and verse, since I don't see it.