-paul
-----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 ______________________________________________________________________ Dedicated Windows 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=coldfusiona 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
