[PHP] <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#">[/php]

I am using the code above to create a Query that inserts multiple records.

Buy I have a extra coma at the end.

how can i have it that the last coma does not sohw

Thanks