in reply to dbi & placeholders: getting the actual sql

Here is what I do sometimes during debugging to see what values will be put into the placeholders by DBI for me:

my $statement = $sql;
$statement =~ s/\?/$dbh->quote($_)/e for @bindvals;

print "The SQL query will be: [$statement]";

[download]

In Section Seekers of Perl Wisdom