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

This can be a good trick... but it is not generally applicable... since it won't work, in general, for multiple inserts. I say "in general" because there are cases where you can do things like: 
insert into table1 (val1,val2,val3)
select val1,val2,val3
from table2
where id in (?,?,?,?,...)

[download]
but... again, that will only be an available option some of the time.

------------
:Wq
Not an editor command: Wq
  • Comment on Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE
  • Download Code

In Section Meditations