I also wanted to mention... I have had to do similar things in the past
and have found the Split UDF very helpful.
http://www.cflib.org/udf.cfm?ID=1184
If you use that your code could easily be something like this....
<cfloop index="UU" list="#form.grade#" delimiters=",">
<!--- PROCESS EACH UU VALUE HERE --->
<cfset x = split(UU,"-")>
<!--- Now the Student ID is stored in x[1] and the Grade is
stored in x[2] --->
<cfquery>
Update STUDENTGRADETABLE
SET grade = '#x[2]#'
WHERE StudentID = #x[1]#
</cfquery>
<!--- Other processing as necessary --->
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2854
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
