QuoteSQL

[Lawrence D'Oliveiro]

In message <efeqpd$8vh$1 at lust.ihug.co.nz>, LI wrote:

>>>> execfile("QuoteSQL.py")
>>>> EscapeSQLWild(r"\%")
> '\\\\%'
>>>> SQLString("%" + EscapeSQLWild(r"\%") + "%")
> '"%\\\\\\\\%%"'
>>>> EscapeSQLWild(r"\%") == r"\\%"
> True
>>>> SQLString("%" + EscapeSQLWild(r"\%") + "%") == r'"%\\\\%%"'
> True

With the correction to EscapeSQLWild, this becomes:

>>> execfile("QuoteSQL.py")
>>> EscapeSQLWild(r"\%")
'\\\\\\%'
>>> SQLString("%" + EscapeSQLWild(r"\%") + "%")
'"%\\\\\\\\\\\\%%"'
>>> EscapeSQLWild(r"\%") == r"\\\%"
True
>>> SQLString("%" + EscapeSQLWild(r"\%") + "%") == r'"%\\\\\\%%"'
True