[Zope] zsql puzzler

jwsacksteder@ramprecision.com jwsacksteder@ramprecision.com
Tue, 8 Apr 2003 15:42:00 -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.