> I've tried several iterations of this code, but I'm just not > getting it. Am > I on the wrong track? Is there an easier way? a better way? > > here's the code I'm working with now: > > <cfloop from="1" to="#ListLen(form.EmpID_Muster)#" index="i"> > > <cfquery name="qUpdate_Status" datasource="MorningMuster"> > > UPDATE Muster > > SET Emp_Status = #form.Emp_Status# > WHERE EmpID_Muster = #form.EmpID_Muster# > > </cfquery> > > </cfloop> >
You want to use listGetAt to get the proper item: <cfloop from="1" to="#ListLen(form.EmpID_Muster)#" index="i"> <cfquery name="qUpdate_Status" datasource="MorningMuster"> UPDATE Muster SET Emp_Status = #listGetAt(form.Emp_Status,i)# WHERE EmpID_Muster = #listGetAt(form.EmpID_Muster)# </cfquery> </cfloop> ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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