If you are returning a POST instead of a GET, I'd name all the checkboxes the same. Make the values the page IDs. You'll get a comma-delimited list which you can parse into a large insert.
If you have to name them individually, prefix them with something similar (ie page_(ID) so, page_23, page_9, etc.). You can loop over the formfields list and extract them. Sorry if that's not clear, but I'm pretty tired. :-) --Ben Joel Watson wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273949 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
