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