no problem Let us know how it works out for you.
William -----Original Message---- -From: [EMAIL PROTECTED] -Date: Sep 18, 2007 13:02 -To: "CF-Talk"<cf-talk@houseoffusion.com> -Subj: Re: One more database question - sorry! - ->Scenario -> ->3 tables -> ->Profile table ->-kpProfileID -> ->profile_hobby table ->-kfProfileID ->-kfHobbyID -> ->Hobby Table ->-kpHobbyID -> ->The Profile table would have as many rows in it as you have customers -> ->The profile_hobby table would have: 1 row per hobby selected in each ->profile -> ->The Hobby table would have 20 rows in it. -> ->Hope this helps, ->William -> -> ->-----Original Message---- ->-From: [EMAIL PROTECTED] ->-Date: Sep 18, 2007 12:37 ->-To: "CF-Talk"<cf-talk@houseoffusion.com> ->-Subj: Re: One more database question - sorry! ->- ->->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? ->- ->- - -Ah, i see now. Being "list-minded", I was assuming that non-selected hobbies would be entered into the mediator table...but obviously that would not be necessary. Thanks for explaining this for me---i really appreciate it! - - ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
