in reply to Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE
in thread Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE

Making fewer database calls when possible is good. You can also do (if there are not too many @values):
my $sta = 'UPDATE foo SET bar = ? WHERE baz in (", join(',', "?" x @va
+lues), ")";

[download]
But I think jZed was just offering a generic example, and on these sorts of updates, I think you often want to set 'bar' equal to something different for each 'baz', so the multiple execution version is more appropriate in that case.
  • Comment on Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE
  • Download Code

In Section Meditations