getting ID directly from the form field associated with that ID

[scottobear]

The final working code

<cfloop list="#FORM.fieldnames#" index="c" delimiters=",">
<cfif listfindnocase("ORDER",listfirst(c,"_"),",")>
<cfset item = "##" & "FORM." & c & "##">
    <cfquery name="reorder" datasource="guidance">
    UPDATE fed_lands_doctype
    SET type_order = <cfqueryparam value="#evaluate(item)#" cfsqltype="cf_sql_numeric">
    WHERE type_id = #listlast(c,"_")#
    </cfquery> 
</cfif>   
</cfloop>

Originally published at The Scotto Grotto. You can comment here or there.