Is there a limit to the number of records a ZSQLMethod can return, something like 1000 records? I ask this, because I am making a tabbed delimited list of records for a Pittney Bowes mail export, and my record set keeps getting capped at 1000 records. I am not setting an explicit limit in my ZSQLMethod, so my suspicion falls on Zope protecting me from large loops. I am already working on moving my DB query out into an External Method, but I was just curious if the limit existed and if there was another way around it. Thanks Chris Meyers I don't want the world, I just want your half --TMBG
Chris Meyers wrote:
Is there a limit to the number of records a ZSQLMethod can return, something like 1000 records? I ask this, because I am making a tabbed delimited list of records for a Pittney Bowes mail export, and my record set keeps getting capped at 1000 records. I am not setting an explicit limit in my ZSQLMethod, so my suspicion falls on Zope protecting me from large loops. I am already working on moving my DB query out into an External Method, but I was just curious if the limit existed and if there was another way around it.
Thanks
Chris Meyers
I don't want the world, I just want your half --TMBG
_______________________________________________ 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 )
Check the advanced tab of the ZSQL Query in question
participants (2)
-
Chris Meyers -
Phil Harris