[Zope-DB] Max query size?

[Harry Wilkinson]

On Monday 14 January 2002 9:54 pm, j2 wrote:
> I try a select fileda,filedb from table
>
> the table has over 4000 lines, but the returned answer only shows 1000
> lines, how come? Is there some max limit i am hitting?
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db

There is a default results limit of 1000 rows.

What kind of method are you using to access your DB?  If you are using ZSQL 
methods there is an option to change the limit in the 'Advanced' tab.  If you 
are using FS ZSQL methods you can set 'max_rows: 0' to disable the limit.  If 
you are using the plain Python interface you can pass the max_rows variable 
as an argument to the query() method.