[Zope] zsql puzzler

[Dieter Maurer]

jwsacksteder@ramprecision.com wrote at 2003-4-8 15:42 -0400:
 > I have a zsql method that is acting rather oddly.
 > 
 > My query is something like this-
 > 
 > 	select girl,type,sum(qty)
 > 	from girlscout_cookie_sales
 > 	group by girl,type
 > 
 > If I enter it directly in my console, I get a list of about 40 lines. If I
 > paste that query into a zsql method, I only get 21 results and no error. The
 > results are not being cached. I am not displaying 20 results at a time.
 > 
 > Where are my results?  I'm stumped as to how to begin troubleshooting this.

Are you sure that both requests go to the same database?


Dieter