P is for Practical | |
PerlMonks |
Re: Can a DBI Placeholder accept multiple values?by runrig (Abbot) |
on Feb 08, 2008 at 22:06 UTC ( [id://667082]=note: print w/replies, xml ) | Need Help?? |
If you're going to prepare/execute this many times, and you only have (up to) a few values, it might be worthwhile to use the join(",", ("?") x $n) technique, and use prepare_cached. If you might have up to many (100?) values, then forget the placeholders and prepare_cached, and use the quote() method on the values if necessary to create dynamic SQL every time.
In Section
Seekers of Perl Wisdom
|
|