update multiple fields with same/diffrent name

I am with Dan on this (identifying the field names with IDs), but prefer cfloop to cfoutput within cfform. Furthermore, I would put the submit button outside the loop.

<cfloop query="qMesg">

    <cfscript>

    ArrayAppend(myIds, "#id#");

    </cfscript>

    <cfinput type="text" value="#mesg#" name="mesg#id#">

    <cfinput type="text" value="#dateformat(sent_date, 'mm-dd-yy')#" name="sent_date#id#" validate="date" />

</cfloop>

<cfinput type="submit" name="submit" value="Update">

With proper handling, one loop should be sufficient on the action page.

<cfloop index="idIdx" list="#form.ids#" delimiters=",">

    <cfset current_message = form["mesg" & idIdx]>

    <cfset current_date_sent = form["sent_date" & idIdx]>

    <cfquery>

    UPDATE tblMessg

    SET mesg = <cfqueryparam value="#current_message#" cfsqltype="cf_sql_varchar">,

    sent_date = <cfqueryparam value="#current_date_sent#" cfsqltype="cf_sql_date">

    WHERE id = <cfqueryparam value="#idIdx#" cfsqltype="cf_sql_integer">

    </cfquery>

</cfloop>

My approach is to do something like this:

on the form page

<cfoutput query= something>

<input name = staticpart#id field from query#>

</cfoutput>

on the processing page

<cfloop list = form.fieldnames index = thisfield>

<cfif left(thisfield, 10) is "staticpart">

<cfscript>

ThisID = replace(thisfield, "staticpart", "");

ThisStaticPartValue = form[thisfield];

ThisOtherValue = form["OtherStaticPart" & ThisID];

then do something with those values