I've also used both approaches with one addition.
In addition to the Lookup object, I also created a List ContentObject Type. the
List COT contains the names of the lists for which Lookup objects exist. For
example, you might have a "State" List COT.
Then in the Lookup objects one of the properties is ListID which contains the
UUID of the list the item is associated with. This allows you to manage multiple
lists and related lookup objects.
When the application starts, it queries for the Lists and the Lookup objects and
creates various applicatoin-level variables that contain the Lookup objects. For
states, we might generate a Query (programmatically making one with the Query*()
functions).
At some point in the next week or two, I'm planning to put our code for all of
this onto our site, but am not quite ready with it yet.
HTH
David Aden
-----Original Message-----
From: Rob Rusher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 11:06 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Need a Recommendation
I've used two methods.
One - keep my lookup values in separate tables. I then used those values to
populate objects.
Two - I created a Lookup object that has two properties (type & value).
I've found both to be easy to work with. The deciding factor is usually if I
want to keep everything in Spectra's tables or not.
Regards,
Rusher
Broadiant Corporation
999 18th Street Office (303) 308-2963
Suite 1955 Cellular (720) 939-6661
Denver, CO 80202 Fax (303) 298-7540
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Success usually comes to those who are too busy to be looking for it.
-----Original Message-----
From: Zoaib A. Qureshi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 7:20 AM
To: [EMAIL PROTECTED]
Subject: Need a Recommendation
Hello All, I am currently on a spectra project which involves lots of
Content Management. To insert the content we have multiple forms. Few of
these forms have drop-down boxes. One of the example of the drop-down boxes
is Format Type i.e. PDF, Doc, Avi, etc. My question is regarding these
drop-down boxes. Should I put these values, which are required only for
populating these form fields as Spectra Objects or Should I just use a
separate SQL table for populating these fields. I would appreciate an expert
suggestion.
Thanks in advance for your replies.
ZAQ!
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
