greetings, I have some code that takes a string and breaks it into to components and set each component into a seperate variable.
This code was set up to only take one string and perform this function. Now they want me allow the user to select multiple items from a select box which adds more values to my string and screws up my query. I tried looping through the code to seperat each value when it encounters a comma but it only processes the last item picked. I've tried using the ListGetAt finction but no luck. any thoughts? code: <cfset SelVal = trim(form.AppRegDS)><!---set Form variable--> <cfset qualifiedList1 = ListQualify(SelVal,",")> <cfloop list="#qualifiedList1#" index="ListElement" delimiters="'"> <cfset position = Find("---",ListElement)><!-Look for this value> <cfset variable.App = Mid(ListElement,1, position-1)> <cfset variable.Region = Mid(ListElement,position+3,Len(ListElement))> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4