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