On Nov 10, 11:00 am, Daniel <[EMAIL PROTECTED]> wrote: > Hello, > > I'm developing an application that accesses both a MySQL and an SQLite > database. I would like to have named parameters in my SQL and have > found the following: > > For MySQL my named parameters need to look like this: %(paramname)s > For SQLite my named parameters need to look like this: :paramname > > I have read in PEP249 (http://www.python.org/dev/peps/pep-0249/) that > there are five paramstyles, though it wasn't clear if I should expect > these to be implemented in all DBAPI2 compliant modules. I have found > that I can set the paramstyle, but it doesn't seem to apply: > > >>> import sqlite3 as dbapi2 > >>> dbapi2.paramstyle > 'qmark' > >>> dbapi2.paramstyle = 'format' > >>> dbapi2.paramstyle > > 'pyformat' > > My sqlite access still requires the 'named' format and not > 'pyformat'. > > Can someone tell me if it's possible to configure a connection or > cursor to use a particular paramstyle? > > Thanks.
If no one has any input, can someone tell me where I should post? Thanks -- http://mail.python.org/mailman/listinfo/python-list
