in reply to Re^2: Dynamic SQL
in thread Dynamic SQL

Construct placeholders queries with hard coded options on the fly, no injection possible then.

edit

If you cache them after first use in a hash, you won't have a performance problem.

Eg create a custom function getting a hash ( field =>entry,... ) and preparing only if new and returning result.

Cheers Rolf
(addicted to the Perl Programming Language and ☆☆☆☆ :)
Je suis Charlie!