>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.

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.

Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to