[Zope] ZSQL Method Size?

[Tony McDonald]

At 9:21 am -0500 21/3/00, J. Atwood wrote:
>I have been using <dtml-in sqlMethod size=4 query=start_query> and I find
>that 80% of the time it will return 4 results but sometimes, for no apparent
>reason it will return 5 or 6. This is happening with a few of my ZSQL
>Methods?
>

Are these batches of records the 'last' batch in the ZSQL query?
If so, it's the 'orphan' parameter kicking in, which *I believe* is set to 3.

If you have 19 records returned with a batch of 4, you get
1-4, 5-8,9-12,13-16,17-19 - no problem there

If you have 9 records returned with a batch of 4, you *would get*
1-4, 5-8, 9 (on it's own).

The 'orphan' parameter would make the last batch return 5-9 (ie 5 records).

It's described in greater detail in the ZSQL users guide...
hth
tone
------
Dr Tony McDonald,  FMCC, Networked Learning Environments Project 
http://nle.ncl.ac.uk/
The Medical School, Newcastle University Tel: +44 191 222 5888
Fingerprint: 3450 876D FA41 B926 D3DD  F8C3 F2D0 C3B9 8B38 18A2