hi just wondering what you guys think about the structure of the following cfc scenario, i am having difficulties picturing how to best do it
i have 3 core components to a system materials, projects, and tests they are relating as follows: each project contains various tests, and each test analyzes various materials. the material can also be part of one or many projects: for example they could have 1000 materials, 5 projects, and each project has one or more tests analysing these materials in different ways - a test could also be a part of one or more projects in the database i have 5 tables to represent this: projects, tests, and materials hold their individual information, then they are linked by 2 tables: projecttests (include primary keys from these tables) testmaterials (include primary keys from these tables) this is working fine but when i try to think of this in terms of cfc's then i get a bit lost, as i am new to working with cfc's so would appreciate any advice on what you guys would do. i am thinking there would be a cfc called project, one called test, and one called materials. but then what would i call in order to get the testmaterials for a specific test etc... i know i can normally query the database table to get that information but i am wanting to get to grips with how to best use the cfc's and wonder if you guys have any pointers also, if i wanted to get information about multiple tests, i.e. their test locations, then would i need to create a collection of cfc objects in order to store this data i know this is a lengthy question but i feel if i can get my head around these concepts then i would understand cfc's alot more thanks again for your help richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
