>>- if the resultset were never used the query would never be run on the server;
Well, if the result set is not used, what is the advantage of having the query run anyway? >>- if the resultset were used multiple times the query would be run multiple times on the server; If the result set is too large to fit in memory, it will be rewritten and reread from disk every time anyway. >>- the number of records would be unknown. Most of the time, one only needs to know if there are records or not. This can be checked reading the first record only. May be some parameter in CFQUERY (ie RECORDS="onTheFly") could be used to create on the fly queries. It will be up to the programmer to use it if he expects the query to generate lots of data. In that sense, the parameter blockFactor in CFQUERY is missleading: it says "Specifies the maximum number of rows to fetch at a time from the server. The range is 1 (default)" So I thought that CF was getting rows one at a time. Apparently, it is getting all rows "one at a time" in the same time ;-) Doesn't make much sense to me ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
