Results 1 to 1 of 1
Thread: SplitVar
-
01-09-2010, 03:53 PM #1
SplitVar
Code:<cfset SplitVar = #URL.modelID# /> <cfquery datasource="XXXXXXX" dbname="XXXXXX" name="get_memb"> SET QUOTED_IDENTIFIER OFF INSERT INTO ModelToPart (modelID,ModelPartID) VALUES <cfloop index="intI" from="1" to="#(ListLen( SplitVar, ',' )-1)#" step="1"> <cftry> ('#URL.modelID#',' #ListGetAt( SplitVar, intI+1, "," )#') , <cfcatch> ERROR: #CFCATCH.Message# </cfcatch> </cftry> </cfloop> </cfquery> <cflocation url="http://www.modelproductions.com/book_NweProjct_viewPart.cfm?modelProjectID=#URL.modelProjectID#">




Reply With Quote

