What we are really talking about here is having the right tool for the job.
dBase, Clipper and FoxPro are all database management systems, and so are designed to work efficiently in examples like the one you are citing. ColdFusion is a Web Application server, designed to interact with a database to deliver web content. By the very nature of Web applications, you wouldn't want to be leaving open database connections all over the place - the surest way to crash a server under heavy load... Really, all the heavy lifting should be done within the database itself; but out of preference I don't think I'd be using Acces for this! However, you can do what you want using ColdFusion; I've done similar stuff in the past when the updating has required extra ColdFusion logic. I would just recommend doing it in chunks of data - maybe 5000 records at a time? Grab the first 5000 records; process them; then do the next 5000... >>> I don't think this is unexpected behaviour > > It is not only unexpected, it is completely retarded. > All ODBC/JDBC functions are designed so the database can be connected, > then the SQL statement be compiled, then data retrieved row by row, as > needed. Even dBase, Clipper, Foxpro worked this way. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
