SplitVar

Discussion in 'Programming' started by moiseszaragoza, Jul 15, 2009.

  1. #1
    	 	<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
     
    moiseszaragoza, Jul 15, 2009 IP