OK, got it to work. Below is actual code, instead of the previous example I
sent.
I'm updating two fields: MSTRSub and MSTRStat, which show the current value
in the database as well.
#ViewAllApps.MSTR_ID# is the record number for each record in the loop.
So, the loop and form looks like:
<cfloop query="ViewAllApps">
<form method="POST" action="#CurrentPage#" name="modSTATS">
<select name="MSTRSub_#ViewAllApps.MSTR_ID#">
<option value="#ViewAllApps.MSTRSub#">#ViewAllApps.MSTRSub#</option>
<option value="Incomplete">Incomplete</option>
<option value="Submitted">Submitted</option>
<option value="Processing">Processing</option>
<option value="Done">Done</option>
<option value="No">No</option>
</select>
<select name="MSTRStat_#ViewAllApps.MSTR_ID#">
<option value="#ViewAllApps.MSTRStat#">#ViewAllApps.MSTRStat#</option>
<option value="Conditional Approval">Conditional Approval</option>
<option value="Waiting">Waiting</option>
<option value="Suspend">Suspend</option>
<option value="Cleared to Close">Cleared to Close</option>
<option value="Turned Down">Turned Down</option>
</select>
</form>
</cfloop>
..and the processing section looks like:
<cfloop index="loopIDX" list="#Form.RecID#">
<cfquery datasource="OneChoice" username="xxx" password="xxx">
UPDATE dbo.app_Master
SET MSTR_Submit = '#evaluate("FORM.MSTRSub_#loopIDX#")#',
MSTR_Status = '#evaluate("FORM.MSTRStat_#loopIDX#")#'
WHERE MSTR_ID= #loopIDX#
</cfquery>
</cfloop>
Is working great! Thanks for those that helped!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
