Re: silva sql code source: limit

>> 2007/10/5, Marc Petitmermet <[email protected]>:
>> > is it possible to change the silva sql code source so that the
>> > default LIMIT 1000 can be overridden? this limit is rather limiting;-)
>>
>> in the meantime i migrated my silva sql code source to a standard
>> silva code source. nonetheless, it would really be great to have this
>> LIMIT limitation removed. silva sql code source comes with a nice
>> free layout and is very convenient.
>
>That's the limit on the number of results of a query? What would you
>like it to be?
>
>I'm not sure why there's a limit, but I haven't looked in the code.

standard zsql-method objects have a LIMIT of 1000. but this can be overridden in the advanced tab by setting the maximum rows to retrieve to 0. when this is set users can set their own LIMIT within the sql-query. maybe silva sql code source could just include such a field as well in the edit tab?

regards,
marc