You could user currentrow like so. <input type="hidden" name="records" value="#set_Emp.recordcount#"> <cfloop query="set_Emp"> <INPUT TYPE="text" NAME="PhoneNumb#currentrow#" VALUE="#Trim(PhoneNumb)#" SIZE="14" MAXLENGTH="14" class='input'> <input type='hidden' name='PhoneID#currentrow#' value='#Trim(PhoneID)#'> <br> </cfloop>
Then in the action page, do something like this. <cfquery name="UpdatePhone" datasource="RPH" dbtype="ODBC"> <cfloop from="1" to="#FORM.records#" index="Emp"> UPDATE tblPhone SET PhoneNumb='evaluate(#FORM.PhoneNumb# & #Emp#)' WHERE tblPhone.EmpResID = '#FORM.EMPLOYEE_ID#' AND tblPhone.PhoneID = 'evaluate(#FORM.PhoneID# & #Emp#)' </cfloop> </cfquery> _____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 12:07 PM To: CF-Talk Subject: Update multiple rows ok i am trying to update multiple rows based on a form element that loops over a query can this be done? my action in the UPDATE is not working right. using sql 7. i could just do one at a time easy enough. but would like to do them together. <!--- Form Page ---> <cfloop query="set_Emp"> <INPUT TYPE="text" NAME="PhoneNumb" VALUE="#Trim(PhoneNumb)#" SIZE="14" MAXLENGTH="14" class='input'> <input type='hidden' name='PhoneID' value='#Trim(PhoneID)#'> <br> </cfloop> <!--- Action Page ---> <cfquery name="UpdatePhone" datasource="RPH" dbtype="ODBC"> UPDATE tblPhone SET PhoneNumb='#FORM.PhoneNumb#' WHERE tblPhone.EmpResID = '#FORM.EMPLOYEE_ID#' AND tblPhone.PhoneID = '#FORM.PhoneID#'</cfquery> Thank You -paul ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
