>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"<cf-talk@houseoffusion.com> >-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 >- >-
So let's say that my form has 20 hobbies/interests. I would be creating 20 entries in this middle table, correct? Is this going to create a problem if I have hundreds of users? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4