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

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.

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