[Zope] zsql puzzler

[Geir Bækholt]

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