On 9/18/07, Joel Watson <[EMAIL PROTECTED]> wrote: > > 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?
Depends on if you need to REPORT on that data =) There are definately places where I'll store data like that in a single text field.. and other places where I give each piece of data its own field in the database. You could even put the data into a struct, convert it to a WDDX packet, and then store it in a text field in the db. When you retrieve it, it's then very easy to turn it back into a coldfusion struct. But again.. as long as you don't need to report on or query on that data. -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
