> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andreas
> Sent: Saturday, June 10, 2000 1:59 AM
> To: Umesh Soni
> Cc: Phill Hugo; [EMAIL PROTECTED]
> Subject: Re: [Zope] ZSQL method broken on 2.1.6
>
> > >>
> &
Andreas writes:
> ZSQLMethod's "advanced" property 'Maximum number of rows retrieved'
> makes no sense to me.
It prevents stupid queries to kill Zope.
Assume, such a query returns 100.000.000 records.
This probably will let Zope require several GB memory.
> As I know so far there is no way to
Umesh Soni wrote:
>
> >Umesh Soni wrote:
> >>
> >> (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
> >>
> >> Hi there,
> >>
> >> I had this ZSQL method (simplified for clarity) working on 2.1.4
> >>
> >> select id, nickname from bboard
> >> where id<=50
> >> order by id des
>Umesh Soni wrote:
>>
>> (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
>>
>> Hi there,
>>
>> I had this ZSQL method (simplified for clarity) working on 2.1.4
>>
>> select id, nickname from bboard
>> where id<=50
>> order by id desc
>> limit 30
>
>Remove either the
Umesh Soni wrote:
>
> (using zope 2.1.6 with ZMySQLDA-2.0.0a1 and MySQLdb-0.2.1)
>
> Hi there,
>
> I had this ZSQL method (simplified for clarity) working on 2.1.4
>
> select id, nickname from bboard
> where id<=50
> order by id desc
> limit 30
Remove either the limit 30 or the LIMIT 1000 Ad