[Zope] zsql limit all doesnt work

Andreas Heckel andreas@easyleading.org
Mon, 04 Mar 2002 11:17:09 +0100


Paz wrote:
> 
> Good morning,
> 
> Im trying to build some data shelfs with sql data and a dtml method and
> I run into a problem where the output is not correct because the
> outermost zsql refuses to pull more than 999 records. I unfortunately
> have very little time to solve it, but hoped maybe someone might see
> this right away. I use the limit all in the zsql but it isn't helping.
> 
> TIA, for desperate measures...
> Paz

Have a look at the Advanced tab of your ZSqlMethod. There is a
(IMHO useless) "Maximum rows to retrieve" property. It's default value
is 1000 :-)


-- 
_______________________________________________________________________
Andreas Heckel                                  andreas@easyleading.org
LINUX is like a wigwam...no gates...no windows and an apache inside ;-)