Re: Dynamic SQL

[sundialsvc4]

This node falls below the community's threshold of quality. You may see it by logging in.

[Your Mother]

…overlooked the fact that the argument to the statement-handle prepare() method is an array of @bind_values.

WAT? Maybe it was overlooked because it’s—channeling BUK—twaddle. It takes a statement with optional hashref of attributes, not an array of anything, let alone bind values; from the DBI docs–

$sth = $dbh->prepare($statement)          or die $dbh->errstr;
$sth = $dbh->prepare($statement, \%attr)  or die $dbh->errstr;

[Anonymous Monk]

So, even though Perl will, if asked, “flatten” method-arguments, you don’t want to be doing that.

Wrong, it is the default behavior of Perl to flatten arguments to subs.