One of the things that the other posters (particularly Matt) were getting at is that many times when you return a query object with a number of records, you're not looking to manipulate any of the records (yet).
You're often listing records from the database so that one can be chosen for manipulation. And since in these cases, you generally need the ID of the record (so that you can choose it) and certain other fields (so the user can identify the record s/he wants), having something like an array of true objects is not really necessary. So the expense of all the object generation may not be justified. You and your boss might, however, want to look at one of the CF ORM frameworks, such as Transfer. Transfer mirrors some of the functionality that your boss might be familiar with in Hibernate (although Mark Mandel, the author, is very adamant about the fact that it is not a port of Hibernate). Although Transfer has methods that let you return traditional CF queries (listByQuery(), for instance), it mostly works with objects -- and often, arrays of objects (for instance, a Person object related to multiple Address objects). It also has caching mechanisms that help make working with those objects somewhat less expensive. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
