Ben, Dinner-- Thank you both for the erudite responses. You have convinced me!
Now for the million-dollar question: As mentioned, I am generating the select boxes dynamically from the "Pages" table. If I am to enter the users inputs from the check boxes, how would I go about parsing out these multiple selections to separate database entries? Initially, I thought about using a database, but this was something I did not know how to do. Any suggestions? (BTW, I am dyanamically naming the checkboxes with the "Page" Id...if that helps). Thanks again for your great help! Joel >Sounds to me like you need a relationship table! > >Get away from the list of values, and instead use a separate table, >with a relation table, which links the two together. > >For the one-offs (if I'm even using that term right) it's no big deal, but >if you're going to be doing a fair bit of stuff with the data... you are >really going to want to "normalize" it. > >MySQL has some fancy and amazingly helpful functions for working >with "list of values" type fields, but still, it's a best practice to normalize >wherever you can... > >Damn you Ben! GMail just pinged me, and I'm betting you just suggested >the same damn thing... yup. Oh well. I'll post this anyway, for emphasis. >(Not conditioning! ;) > >On 3/27/07, Joel W wrote: >> Thanks for the response. One of the issues I am running into is that (and I >> failed to ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
