Louis Zirkel wrote:
It's been my experience that using bind type variables (:name or :value)
with a preceeding : doesn't work properly.
PyGreSQL simply does not support that syntax.
You can check the supported syntax by reading the global "paramstyle".
In PyGreSQL it says "pyformat" which means that you have to use Python
extended format codes (i.e. "%(name)s"). The ":" syntax can only be used
when paramstyle = "named".
As far as I understand, the "paramstyle" is read only. I.e. you simply
have to use that paramstyle; you cannot change it. But the "pyformat"
style is much better than the "named" style anyway.
-- Christoph
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
