On Mon, 4 Mar 2002 sbergmann@weblog.de wrote:
Hi!
Does somebody know if it�s possible to change the default values for the "Advanced Options" in ZMySQLDA? The Default is "Maximum rows to retrieve: 1000" "Maximum results to cache: 100". If I have a big table and want to select more then 1000 rows I always have to change the value after creating a new ZSQLMethod. When I forget these the results are not valid. I tried to to find the Values in the sourcecode but didn�t find.
Bye
Change max_rows_=1000 to something else in class DA in lib/python/Shared/DC/ZRDB/DA.py Will only affect new ZSQL Methods. You could write a Pyscript to loop over all ZSQL objects (use ZopeFind()) and manage_advanced this for current objects. -- Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant