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