[Zope-DB] Error when getting over 20 results
Jonas Nielsen
jonasn at mail.tele.dk
Thu May 4 08:18:44 EDT 2006
I have the following ZSQL method:
select * from pmember where project=<dtml-sqlvar project type="string">
The result should be about 60 records. However it only works if I set
"Maximum rows to retrieve" in the "advanced" tab to a number below 20.
If I don't, I get the following error:
*****************
KeyError
Sorry, a site error occurred.
Traceback (innermost last):
* Module ZPublisher.Publish, line 175, in publish_module_standard
* Module Products.PlacelessTranslationService.PatchStringIO, line
51, in new_publish
* Module ZPublisher.Publish, line 132, in publish
* Module Zope.App.startup, line 204, in zpublisher_exception_hook
* Module ZPublisher.Publish, line 101, in publish
* Module ZPublisher.mapply, line 88, in mapply
* Module ZPublisher.Publish, line 39, in call_object
* Module Shared.DC.ZRDB.DA, line 337, in manage_test
* Module DocumentTemplate.DT_String, line 474, in __call__
* Module DocumentTemplate.DT_In, line 602, in renderwb
* Module DocumentTemplate.DT_Var, line 219, in render
KeyError: 'query' (Also, an error occurred while attempting to render
the standard error message.)
************************
Any idea what the problem is ? I'm using ZMySQLDA 2.0.8 and Zope 2.7.5 .
More information about the Zope-DB
mailing list