[Zope] ZSQL method broken on 2.1.6

Ron Bickers rbickers@logicetc.com
Sun, 11 Jun 2000 18:54:46 -0400


> -----Original Message-----
> From: root@www.ahit.de [mailto:root@www.ahit.de]On Behalf Of Andreas
> Sent: Saturday, June 10, 2000 1:59 AM
> To: Umesh Soni
> Cc: Phill Hugo; zope@zope.org
> Subject: Re: [Zope] ZSQL method broken on 2.1.6
>
> >  >>
> >  >> (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
> >  >>

> As I know so far there is no way to disable this property or to set a
> value like 'maximum'

This version of ZMySQLDA (and possibly others) doesn't put the LIMIT
statement in at all if you set the maximum number of rows to 0 (zero).

Like someone else said, it's a "safety net" for queries that may accidently
return way too many records.
_______________________

Ron Bickers
Logic Etc, Inc.
rbickers@logicetc.com