Am Donnerstag, den 03.11.2005, 09:37 +0700 schrieb Thanh Hải, Hà: > Hello, > > My problem is I don't know to prevent Zope from adding "LIMIT 1000" to > the end of each of my ZSQL method (*.zsql). I am developing a > filesystem-based product so I can not disable it by setting "Maximum > Rows to Retrieve" to zero in the ZMI interface. I got stuck with this > problem for a couple of weeks (google search and read documentation > didn't help). Any help is greatly appreciated.
Go to the advanced tab of your ZSQL method and set the max rows there to 0. IIRC, just adding the LIMIT clause to the query is database adaptor specific. (Others may fetch only max rows from dataset) _______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )