In message <[EMAIL PROTECTED]>, 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
--
http://mail.python.org/mailman/listinfo/python-list
