A query should do the trick.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Steve Brownlee <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Thu Jul 06 19:36:30 2006 Subject: Algorithm / Data dudes Never had to deal with data of this structure and was hoping some of you geniuses had done something similar already and had an elegant solution. Working on Pricing Sheets. For those who don't know what they are, from a data viewpoint, they're simply Excel spreadsheets. - Column Headers - Row Headers - Two-dimentional table of data I'm trying to think of the most efficient way to store this data in a CF memory construct (struct/array). My first thought was simply a four-dimensional array, but then I starting considering a more code-friendly(?) structure where row headers are in one key, column headers in another and the data in a two-dimentional array in the 3rd. However, that seems like a lot of additional logic to match up headers with the data. If you've done something like this before, I'd greatly appreciate any wisdom or advice you can pass my way. Steve "The Boss" Brownlee http://www.orbwave.com/cfjboss ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245651 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4; //Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
