Hey Richard, a couple of questions for clarification: - Is one of the goals of your system to model anything? For example, today it is GPs but tommorow it may be sports-cars, then laptops and so on? Or maybe a little more narrow but similar in concept, nurses, interns, surgeons, etc? If so, would you store that primary id in the "lookup" table? - Is the "lookupValues" table where you store *possible* values for a given field and lookupData where you store the actual value? For example a column of "title" would have lookupValues of "Mr.,Dr.,Mrs.etc." and a lookupData of just "Dr."?
Cheers, Baz On Mon, Sep 15, 2008 at 7:01 AM, Richard (J7) <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > > > > Regards, > > Richard White BSc (Hons), MBCS > > Director > > J7IS Ltd > > Web Application Development > > > > *Contact Details:* > > Email 1: [EMAIL PROTECTED] > > Email 2: [EMAIL PROTECTED] > > Web: www.j7is.co.uk > > Tel: +44 (0)798 472 1810 > > > > *Head Office (Postal Address):* > > J7 Group > > University College London > > Department of Computer Science > > Gower Street > > London > > WC1E 6BT > > > > *Registered Details:* > > *J7IS Ltd* > > *3a Livingstone Court* > > *55 Peel Road*** > > *Harrow*** > > *Middlesex* > > *HA3 7QT* > > * * > > *Company Number: 05613376* > > *VAT Number: 924 9392 93* > > > > > --------------------------------------------------------------------------------- > > > > This e-mail is confidential and privileged. If you are not the intended > recipient please accept our apologies; please do not disclose, copy or > distribute information in this e-mail or take any action in reliance on its > contents: to do so is strictly prohibited and may be unlawful. Please inform > us that this message has gone astray before deleting it. Thank you for your > co-operation. > > > > > > > > > > > > > > > > > > > > > > > > > > * * > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
