> Structure or Array? > > I have a large table that I want in server memory but I'm not > sure what the best route to follow is. There are many columns. > Let say its White Pages information. > > Tables Columns e.g. : > > ID, FirstName, LastName, Address, City, State, Zip and Notes > > What is the best route to follow for a CFQUERY e.g. (Select * > From Table) to place all its information into a structure or > array?
Why bother with this at all? You can simply store the query object in server memory. A query, by itself, doesn't really translate well into either a single structure or array; it can be thought of as a structure of arrays, in which each (single-dimensional) array represents a column, and the structure contains those columns. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
