Re: [Zope] ZSQL method broken on 2.1.6

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