Re: Sync paramstyle between sqlite and mysql

2008-11-11 Thread Thorsten Kampe
* Jerry Hill (Tue, 11 Nov 2008 11:24:50 -0500) > On Mon, Nov 10, 2008 at 1:00 PM, Daniel <[EMAIL PROTECTED]> wrote: > > 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

Re: Sync paramstyle between sqlite and mysql

2008-11-11 Thread Jerry Hill
On Mon, Nov 10, 2008 at 1:00 PM, Daniel <[EMAIL PROTECTED]> wrote: > 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 se

Re: Sync paramstyle between sqlite and mysql

2008-11-11 Thread Daniel
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: %(paramna

Sync paramstyle between sqlite and mysql

2008-11-10 Thread Daniel
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: :paramn