On Mon, Mar 9, 2009 at 4:41 PM, Dominic Watson wrote: >> 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
It is not strictly true. You can declare a cursor, do a move end, read from the metadata how many records you moved forward, then do a move start and wait for the commands to fetch rows. But that is hardly portable and will perform even worse then just fetching everything into a detached recordset on the client. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320292 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4