[Zope] ZSQL method broken on 2.1.6
Umesh Soni
u.soni@cs.ucl.ac.uk
Fri, 09 Jun 2000 18:31:04 +0100
>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 Advanced property of the
>ZSQL method (advanced tab). To speed things up, the limit 1000 appended
>to the query to stop MySQL giving Zope lots of lines when it only wants
>1000 anyway. Its not too clever though. There should maybe be a check to
>see if "limit x" exists in the query.
>
>Phill
>
Thanks Phill, that did the trick --strange thing though the 'Maximum
number of rows retrieved attribute' was set to 100 not 1000 as the
error reported --I changed it to 30.
Anyway it's working now --cheers.
Umesh Soni.