I think I have tracked down a bug that was being triggered by
Zope3's database adapter.
>>> import psycopg
>>> con = psycopg.connect('')
>>> cur = con.cursor()
>>> cur.execute("create table foo (bar text)")
>>> cur.execute("insert into foo values ('100%')", {})
Traceback (most recent call last):
File "<stdin>", line 1, in ?
TypeError: unindexable object
>>> cur.execute("insert into foo values ('100%%')", {})
>>> cur.execute("select * from foo")
>>> print cur.fetchall()
[('100%%',)]
How a single quote triggers the problem, yet a double %%
gets passed through fine, confuses me :-)
--
Stuart Bishop <stuart-4lSSOvFEPszcGevYNGnvVw@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/
PGP.sig
Description: This is a digitally signed message part
_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg
|