Why do this?
duncan.booth at invalid.invalid
Mon Oct 9 13:18:59 CEST 2006
Lawrence D'Oliveiro <ldo at geek-central.gen.new_zealand> wrote:
>>> I use the above when I can, when I can't I fall back on
>> Yes, so you said, but you never came up with a convincing use case
>> where that function was better than using the parameterised queries.
> First of all, the parametrization doesn't handle wildcards, as we
> discussed previously.
No, your separate function for escaping wildcards is fine, and works in
conjunction with parameterized queries. It's the SQLString function you
never managed to justify.
> Secondly, it's less convenient for cases where a dynamic query is being
> built. I previously gave the SQLStringList example. If that's not enough,
> here's another (simple) one:
See Frederik's excellent response on this point.
More information about the Python-list