> On 9/18/07, Joel Watson <[EMAIL PROTECTED]> wrote: > > > > 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? > > Since you're only storing profile IDs and hobby IDs in that table, > you > could put a million rows in there with no problem.... even Access > could handle that :) > > That's certainly the most flexible way to go about storing this kind > of data.. easily allowing you to add/remove hobbies at will, and > report on the data, which you clearly are going to need to be able to > do. > > -- > Rick Root > Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at > www.opensourcecf. com
Excellent. Thanks so much for the advice and instruction! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4