I think you mis-understood Nick. My database has tons of data to query, the only thing it does not have is data-categories (or, they are inaccurate and the accounting group does not want to fix them across 4 companies)
I have an excel list from the accounting group they want me to create reports from. The list is simply GL Account numbers, about 12 pages worth (probably 300 GL accounts in different groups) I don't want it to be a pain to administer, and I'm not sure I want to create a table to hold these hard-coded GL account numbers, and am just looking for other's idea's how to 'hard code' a list of GL accounts to be categorized and reported upon =) Chris -----Original Message----- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 3:31 PM To: CF-Talk Subject: RE: Storing hard coded data - advice? I wouldn't reply on cf to do any kind of data mappings other than select data back to display. Look into data warehousing database modeling (star schema) if you have extensive amounts of historical data. -----Original Message----- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 12:25 PM To: CF-Talk Subject: Storing hard coded data - advice? I have about 12 excel pages of GL Accounts that I have been asked to build reports on. I have separate GL lists for 4 different companies, and each company's data is grouped into categories (Fuel, Property Taxes, Payroll, etc), and have a variable number of GL's per category. Each account is designated as a Major (only match left 4 characters) or Minor account (match all 6 characters). The accountants are telling me this data won't change often (at most they will add an account, or edit once a year) My question is, how would you store this information? Would you just make a SQL table to store it all, or perhaps a structure or array in a config.cfm file that stores it all? Create an XML file? Also, would you bother putting a front end so the users can edit this, or just leave in the DB to be edited by IT only? My source data is a mashup of several iSeries/AS400 data tables. I know several ways to do this, I am just looking for your thoughts or idea's, maybe make this more painless down the road. =) Chris Peterson Gainey Corporation ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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/groups/CF-Talk/message.cfm/messageid:249505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
