Paul, AFAIK, you can only update multiple rows at the same time if you are updating the rows to the same value(s). Since each of your updates are unique, then each query must be run separately.
Kathryn Butterly Web Developer Washington Mutual Finance 813 632-4490 [EMAIL PROTECTED] -----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 ______________________________________________________________________ Get Your Own 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=coldfusionb 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
