Another option would be to create a lookup object and stick all the data for
dropdown lists in there. We've been doing this on a few sites and it works
great. You create a lookup object with a label, description, and group. Each
group would represent one dropdown list. For instance, with your example
below you could have a "format" group and you would enter all the format
types in the "label" property. It is slower to get the data from the Spectra
DB than it would be from another table, but if you set it up so you get this
data only at application startup and stick it in the application scope, it
will only run once and speed isn't as much of a factor anymore.
Either way works fine, but I prefer prefer a lookup object because it's
sticking with the content object layout Spectra uses and doesn't clutter up
the DB with extra tables.
Jason
-----Original Message-----
From: Alan Ford [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 05, 2000 8:43 AM
To: [EMAIL PROTECTED]
Subject: Re: Need a Recommendation
My vote would always be for a non-Spectra SQL table for such things.
Retrieving them from the object database would be tediously slow. It is less
important in an editor than in a page that is going to be hit by everyone
every day, but it is far too easy to be tempted to create Spectra objects
for everything when you do not in fact need to.
Alan Ford
-----Original Message-----
From: Zoaib A. Qureshi <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, August 03, 2000 2:30 PM
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.
