I just did a presentation about this to my local cfug. It's
close, but not exactly your scenario.
Shows another use of array notation. The scenario is the the
user sees a bunch of records and can add a date to any of them.
This will update the db table.
On the form page.
<cfquery name = "q1">
select id
from sometables
where whatever
</cfquery>
<cfform>
<cfoutput query="q1">
<cfinput name = "date#id#"> <!--- note variable
portion of input name --->
etc
On the action page
<cfloop list = "#form.fieldnames#" index = "ThisField">
<cfif left(ThisField, 4) is "date" and len(form[ThisField]
gt 0>
<!--- assume yyyy-mm-dd --->
<cfset ThisValue = CreateDate(left(form[ThisField], 4),
mid(form[ThisField], 6, 2), right(form[ThisField], 2)>
<cfset ThisRecord = RemoveChars(ThisField, 1, 4)>
<cfquery>
update SomeTable
set SomeField = <cfqueryparam cfsqltype="cf_sql_date"
value="#ThisValue#" >
where TheIdField = <cfqueryparam
cfsqltype="cf_sql_integer" value="#ThisRecord#" >
</cfif>
</cfloop>