[Zope] MySQL product

[Capesius, Alan]

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