Thanks everyone for all the great suggestions. I've been out sick so my
colleague took over and this is what she got to work:
<cfloop list = "#mcd#" delimiters="," index="listelement">
<cfquery name="insert_mcd">
insert into RTP_MCD (RTP_ID, MCD)
values (#newid.tempid#, #listelement#)
</cfquery>
</cfloop>
I really appreciate all the help!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4067
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15