Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Paul Boddie
On Sunday 12 August 2007 00:33, Mike Meyer wrote: > On Sat, 11 Aug 2007 17:10:34 -0400 Carsten Haese <[EMAIL PROTECTED]> wrote: > > > > The iron-clad, all-encompassing, golden rule is this: If something looks > > like a parameter marker and occurs in a place where a parameter marker > > is syntact

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Carsten Haese
On Sat, 2007-08-11 at 18:33 -0400, Mike Meyer wrote: > On Sat, 11 Aug 2007 17:10:34 -0400 Carsten Haese <[EMAIL PROTECTED]> wrote: > > The iron-clad, all-encompassing, golden rule is this: If something looks > > like a parameter marker and occurs in a place where a parameter marker > > is syntactic

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Mike Meyer
On Sat, 11 Aug 2007 17:10:34 -0400 Carsten Haese <[EMAIL PROTECTED]> wrote: > On Sat, 2007-08-11 at 15:32 -0400, Mike Meyer wrote: > > On Sat, 11 Aug 2007 18:14:16 +0200 Paul Boddie <[EMAIL PROTECTED]> wrote: > > > On Saturday 11 August 2007 10:25, Mike Meyer wrote: > > > > > > > > Well, InformixD

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Carsten Haese
On Sat, 2007-08-11 at 15:32 -0400, Mike Meyer wrote: > On Sat, 11 Aug 2007 18:14:16 +0200 Paul Boddie <[EMAIL PROTECTED]> wrote: > > On Saturday 11 August 2007 10:25, Mike Meyer wrote: > > > > > > Well, InformixDB has a way that works. I can think of at least two > > > other databases that it won't

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Mike Meyer
On Sat, 11 Aug 2007 18:14:16 +0200 Paul Boddie <[EMAIL PROTECTED]> wrote: > On Saturday 11 August 2007 10:25, Mike Meyer wrote: > > > > Well, InformixDB has a way that works. I can think of at least two > > other databases that it won't work for - or at least, will have > > surprising consequences

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Paul Boddie
On Saturday 11 August 2007 10:25, Mike Meyer wrote: > > Well, InformixDB has a way that works. I can think of at least two > other databases that it won't work for - or at least, will have > surprising consequences for users. That's not the same thing as the > paramstyle having a way. Can you name

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Mike Meyer
On Sat, 11 Aug 2007 09:13:57 -0400 Carsten Haese <[EMAIL PROTECTED]> wrote: > On Sat, 2007-08-11 at 04:25 -0400, Mike Meyer wrote: > > On Fri, 10 Aug 2007 20:24:17 -0400 Carsten Haese <[EMAIL PROTECTED]> wrote: > > > As I said, there is a defined way: Don't treat things that look like > > > parame

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Carsten Haese
On Sat, 2007-08-11 at 04:25 -0400, Mike Meyer wrote: > On Fri, 10 Aug 2007 20:24:17 -0400 Carsten Haese <[EMAIL PROTECTED]> wrote: > > As I said, there is a defined way: Don't treat things that look like > > parameter markers as parameter markers if they appear inside > > apostrophes. This may requ

Re: [DB-SIG] In praise of pyformat

2007-08-11 Thread Mike Meyer
On Fri, 10 Aug 2007 20:24:17 -0400 Carsten Haese <[EMAIL PROTECTED]> wrote: > On Fri, 2007-08-10 at 16:11 -0400, Mike Meyer wrote: > > 2) You have to use '%%' to get a real '%' into the query. > > As for #2, yes, you have to use '%%' to insert a single '%'. How do > > the other paramstyles deal wit