Re: [SQLObject] bug report: limit(num) method for Firebird

[Oleg B. <ph...@ph...>]

On Wed, Mar 16, 2011 at 11:08:52PM +0300, Oleg Broytman wrote:
> On Wed, Mar 16, 2011 at 02:33:48PM -0400, Joe Lanese wrote:
> > I just came across the exact same problem using the mssql connection
> > (mssqlconnection.py).  More specifically the problem occured when I tried to
> > access the first returned row of a selectResults (ie. selResults[0]).  I
> > tried the same solution below in the mssqlconnection.py file, and it solved
> > the problem.
> > 
> > Can this fix also be applied to the official mssql support?
> > 
> > > On Fri, Dec 18, 2009 at 01:19:25AM +0100, Petr Jake?? wrote:
> > > Index: firebirdconnection.py
> > > ===================================================================
> > > --- firebirdconnection.py       (revision 4047)
> > > +++ firebirdconnection.py       (working copy)
> > > @@ -10,6 +10,8 @@
> > >     dbName = 'firebird'
> > >     schemes = [dbName]
> > >
> > > +    limit_re = re.compile('^\s*(select )(.*)', re.IGNORECASE)
> 
>    Thank you, I'll apply the patch tomorrow. New releases will be
> released in a few days.

   Applied and committed in the revisions 4358-4360 (branches 0.15, 1.0
and the trunk; I've stopped maintaining branch 0.14 as I am releasing
version 1.0 RSN.)

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.