hi, we have a feature in out software that allows users to create multi column lookups: e.g. they can create a lookup for gp which would look like the following:
value | gp name | go title | gp address 1 | etc.... --------------------------------------------------------- 0 Smith Dr 25 Gate Road ..... 1 May Dr 12 Old Street ...... the user can add any columns they want, and then add as many values as they want, and start adding gp details in the grid in the database we have 4 tables to store this data: table 1) lookup (which stores just the name of the lookup - in this case gp) table 2) lookupValues (which store the values - 0,1,2 etc....) table 3) lookupColumns (which store the columns - 'GP Name', 'GP Title', 'GP Address 1', etc...) table 4) lookupData (which holds the actual data and references to the value and columns that it is data for - e.g. it holds lookupName=GP, lookupValue=1, lookupColumn=GP Name, lookupData=Smith) we are getting stuck on knowing the correct way to model this in cfc's and OO. we usually create a Bean for the object, a service, a gateway, and a dao. but where do we start for this? do we have a single lookup bean and then a gateway and dao for each table, or do we simply have one bean, service, gateway, dao. if we have one bean then how are the properties of that bean going to be built up, and how are the getters and setters going to reflect this grid structure of this lookup object. really appreciate any help, thanks richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312506 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
