you can create a middle table between the two that has 1 profile key and 1 hobby key per row. Each profile could have multiple hobbies. This would keep you away from the 'dreaded' comma dilimited list in a table cell.
William -----Original Message---- -From: [EMAIL PROTECTED] -Date: Sep 18, 2007 12:19 -To: "CF-Talk"<[email protected]> -Subj: One more database question - sorry! - -Actually, I have one more database question. I have a section on my profile-collection form that is a series of radio buttons for hobbies/interests. What would be the best way to manage/store these values? - -My initial thought was to create a table with a row for every hobby/interest item. Then, on the profile table, I was thinking of having a column that would collect a list of comma delimited values from the form, from 1 to the number of the hobby/interest items. The list would basically match up, sequentially, to the key values of the hobby/interest table. - -Is there a better way to go about this? - -Thanks to everyone for input! - -Joel - - ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
