Thunderstone Software Document Retreival and Management
Search:
Advanced Search
Home | Products | Company | News | Tech Support | Demos | Contact Us
Vortex Manual

$rows.min, $rows.max

The $rows.min and $rows.max variables are set at every iteration, and at the end, of a SQL loop. They are the minimum and maximum total rows that will be returned by the SQL query. In cases where the exact number of result rows is not yet known (eg. post-processing is required), the two will differ. If the upper or lower limit is not known (eg. a completely unindexed query), one or both variables will be negative. If both variables are equal, the total row count is exact.

A one-row look-ahead feature is enabled with $rows.min, such that if $rows.min is greater than $next (either in the loop or after), at least one more row exists in the result set.

See p.  gif for more on these variables.


Copyright © Thunderstone Software     Last updated: Wed Aug 6 11:57:09 EDT 2008
 
Home   ::   Products   ::   Company   ::   News   ::   Tech Support   ::   Demos   ::   Contact Us
Copyright © 2008 Thunderstone Software LLC. All rights reserved.