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 ;-)