So - maybe something like this:
<!--- assign new project an id_number... --->
<cfquery name="newid" maxrows="1">
SELECT RTP_MASTER_SEQUENCE.NEXTVAL AS TEMPID FROM DUAL
</cfquery>
<cfset ThisNewID = #newid.tempid #>
<cfloop From = "1" TO = "#ListLen(mcd)#" INDEX = "#mcd#">
<cfquery name="insert_mcd">
insert into RTP_MCD
(RTP_ID, MCD)
values
('#ThisNewID#', '#mcd#')
</cfquery>
</cfloop>
I'm not sure - I'll be honest - I am having my own brain cramps today - not
quite thinking straight myself.
- N
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4055
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
