I used the cfdump and the form is passing a comma separated list of values, so that's good. As to your question Nick, my preference for how to use the data is to generate multiple database entries in this one table. There is a many-to-many relationship between mcd and rtp_id. I have a rtp_master table, which houses most of the data related to the rtp project (rtp_id being the primary key of that table) and a mcd table with a primary key of mcd. The table this data is getting sent to is a bridge table between the other two. The data should get entered one at a time, in multiple rows. So if the user chose mcd 7335, 7345, and 7610 for rtp 200 I should end up with 3 rows of data: 200, 7335; 200, 7345 and 200, 7610.
I think I need to loop over the query to make this work, it's just that none of the ways I've tried to use to loop are working. Sorry for being misleading in the first post. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4056 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
