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??
Hi, Sheree Look on the "Advanced" tab of your Z SQL Method. -- Jim Washington 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.
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??
In a ZSQL method, just append it with LIMIT ALL or whatever maxHits you want. Paz -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org] On Behalf Of Jens Vagelpohl Sent: Wednesday, November 07, 2001 7: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 )
participants (4)
-
Beaudette, Sheree -
Jens Vagelpohl -
Jim Washington -
Paul Zwarts