Thank you so much, this was a great help! I wasn't able to get the "split"
feature to work but I found something similar online that recommended
ListToArray and I was successful with this:
<cfloop index="UU" list="#FORM.grade#" delimiters=",">
<cfset pKey = ListToArray(UU, "-")>
<cfquery datasource="xxx">
UPDATE students
SET grade = '#pKey[2]#'
WHERE primaryKey = #pKey[1]#
</cfquery>
<cfoutput>
#pKey[1]# #pKey[2]#<br />
</cfoutput>
</cfloop>
Thanks again so much, this saved me a lot of code and I learned something new!
You rock!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2855
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
