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.
On Tue, 8 Apr 2003 15:42:00 -0400 GMT (..21:42 where i live(GMT+1) ) jwsacksteder@ramprecision.com asked the Zope mailinglist about the following: jrc> I have a zsql method that is acting rather oddly. .... jrc> If I enter it directly in my console, I get a list of about 40 lines. If I jrc> paste that query into a zsql method, I only get 21 results and no error. The jrc> results are not being cached. I am not displaying 20 results at a time. jrc> Where are my results? I'm stumped as to how to begin troubleshooting this. what kind of databse are you using ? Perhaps you added the last 19 records from the console in a transaction that has not been committed ? - sorry if it sounds silly, but i have done that trick a lot of times myself... -- Geir Bækholt
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
participants (3)
-
Dieter Maurer -
Geir Bækholt -
jwsacksteder＠ramprecision.com