On Wed, 1 Aug 2007, Terry Carroll wrote:

> Does the "?" approach not work with PRAGMA commands or something; or am I
> doing this wrong?

Just a quick follow-up on this, in case anyone else cares.  My conclusion
is that it's not supported.  Googling around I found this pysqlite bug
report:

http://www.initd.org/tracker/pysqlite/ticket/160

It's not quite on target, since it's trying to use substitution for
non-SQL variables in an SQL statement, but I think the principle is the
same.  The PRAGMA statement is not really an SQL statement, so the
variables in it are not SQL variables.  So this is not-working as
designed, I think.

_______________________________________________
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor

Reply via email to