[OT] Query design question

My database schema references a number of lookup tables. For example, DATA: id primary key category references lookup_category(key) upload_loc references lookup_upload_location(key) (etc) LOOKUP_CATEGORY: key primary key name description

Re: [OT] Query design question

] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 12:28 PM Subject: [OT] Query design question My database schema references a number of lookup tables. For example, DATA: id primary key category references lookup_category(key) upload_loc references

Re: [OT] Query design question

Simon, Thanks for the suggestion - that's a good idea with less OH. Also makes me think of just storing them in a application level Hashmap bean or something loaded at application startup, which is how I handle form collections.. Hmmm.. Becky Bald man looks more like a lady with a bouffant

Re: [OT] Query design question

Subject: Re: [OT] Query design question Simon, Thanks for the suggestion - that's a good idea with less OH. Also makes me think of just storing them in a application level Hashmap bean or something loaded at application startup, which is how I handle form collections.. Hmmm.. Becky Bald