And I was almost going to say, "but Claude will post that a delimited list is a great idea" to save you the trouble. -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/
On 2 August 2011 02:43, <> wrote: > > A cross table is definitely THE standard way to do it. > > Although it is not considered "good practice" by database ayatollah, > a delimited list may be an option when a "reasonable" number of possible > values is involved. > there are several advantages: > 1º it is simpler to update in the database in case of modifications (only > one field in one query); > 2º the list is return directly in a list of checkbox input fields. > 3º the select query returns directly a list, I'm still looking for a way to > get directly a list in a query using a cross table. > 4º CF is especially well equiped for list manipulation. > However you have to make sure that the number of possible values cannot get > too large in the future. > > For instance I use this technique for registration to activities in a > convention. > Participants will never attend thousands of activities, even in a 15 days > convention. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
