(dkubb) Re: (2) dbi & placeholders: getting the actual sql

[Anonymous Monk]

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]";