I'm completely stumped. Nothing I've tried seems to work. All I need to do is turn the query below, which inserts multiple records, into a function and then invoke that function.
<cfloop from="1" to="#form.totalPERSONS#" index="idx"> <cfquery name="WRITE_ENROLL"> INSERT INTO participants ( enrID, part_class ) VALUES ( #evaluate("form.enrID#idx#")#, '#evaluate("form.part_class#idx#")#' ) </cfquery> </cfloop> How would you folks handle this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4