Lawrence D'Oliveiro <[EMAIL PROTECTED]> wrote: >>> I use the above when I can, when I can't I fall back on >>><http://groups.google.co.nz/[EMAIL PROTECTED]>, >>><http://groups.google.co.nz/[EMAIL PROTECTED]>. >> >> 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. -- http://mail.python.org/mailman/listinfo/python-list
