I'd just be sure not to confuse users where two selections in a given selet
box are the same -- the one from the DB and then the matching static choice.
Glad to be of service, though.
--Ben Doom
Programmer & General Lackey
Moonbow Software
: -----Original Message-----
: From: Les Mizzell [mailto:[EMAIL PROTECTED]]
: Sent: Saturday, December 14, 2002 4:35 PM
: To: CF-Talk
: Subject: RE: Form inside a loop problem - advise please!
:
:
: 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
