> CF just needs all the records all the time because that is the only > way to get a recordcount.
While I don't think that is quite true, I do think there is a good reason for having the resultset downloaded at once. ColdFusion expects you to use the recordset within the single request and this differs from an offline application where it can make sense to keep a connection open to a resultset. Indeed, while the initial query may take longer, it is perhaps better performing than hitting the db on each iteration within the request. Thoughts? Dominic ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
