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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245580
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
