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