Re: Perl DBI - Bind variable when query is inserted as part of db column

"In the simplest case, bind parameters are resolved left-to-right." If the query involves a subquery, it's still the same: "left to right."

Perhaps for this reason, though, it's also possible to find modules on CPAN that let you substitute the parameters symbolically: "where column1={col1} and..." They use the symbols to correctly build the parameter-list in proper order and then replace the symbols {col1} by the "?" that is required by SQL.

Comment on Re: Perl DBI - Bind variable when query is inserted as part of db column

Replies are listed 'Best First'.
Re^2: Perl DBI - Bind variable when query is inserted as part of db column by Anonymous Monk on Feb 06, 2020 at 16:51 UTC
possible to find modules on CPAN So, you actually know of at least one such module? And you're too much of an expert programmer to link it, or even name it? Wow. Thanks.	[reply]