[Zope] ZSQL batching with dtml-in

[David H]

Ed Colmar wrote:

> Do ZSQL methods communicate with the dtml-in call and understand the 
> "size" attribute?
>
> for example, in this dtml-in statement:
> <dtml-in SQL_get_large_list size=20 start=query_start>
> </dtml-in>
>
> Will the database be queried for all results, and only have 20 
> displayed, or will the database just return the 20 that are needed?
>
> Thanks for the insight!
>
> -Ed
> _______________________________________________

Ed,
Just add a "Z Search Interface" to a folder that can acquire your zSQL 
method(s).  I think it will create a sample of what you want to do in 
either ZPT or DTML.  Then you can experiment.

You can use the "advanced tab" to tell zSqL methods how many data 
records to download per get and how many to cache.

David