Arrays. Hardcoded?
Application scoped arrays. > -----Original Message----- > From: Peterson, Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 10, 2006 3:38 PM > To: CF-Talk > Subject: RE: Storing hard coded data - advice? > > 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:249508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
