Look at the advanced tab of the ZSQLMethod. They default to 1000 rows. Zope Tips and tricks for Windows NT and SQL =========================================== http://twsite.bizland.com/zopetips.htm
-----Original Message----- From: Jens Vagelpohl [mailto:jens@zope.com] Sent: Wednesday, November 07, 2001 12:32 PM To: Beaudette, Sheree Cc: 'zope@zope.org'; Campbell, Bob; Blais, Bernard Subject: Re: [Zope] MySQL product
apart from the actual problem of the software not returning more than 1000 result, trying to produce a dropdown that large sounds like a usability nightmare and will freeze up or crash some browsers.
i recommend you redesign the interface to provide a search interface to restrict the number of results.
jens
On Wednesday, November 7, 2001, at 11:53 , Beaudette, Sheree wrote:
I have the MYSQL product installed in Zope. I'm having a problem getting more than 1,000 rows in a select query I'm using in Zope for a drop down box. We found max rows to be set to 1,000 in db.py in the file system in the products directory. We then changed it to 2,000 just to see if it would work. It does not.
Any suggestions??
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )