Read my next post :) It's been one of those mornings....
_____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 1:25 PM To: CF-Talk Subject: Re: Update multiple rows I am not sure of a SQL function know as 'evaluate'. Shouldn't this: SET PhoneNumb='evaluate("FORM.PhoneNumb" & #Emp#)' Be this: SET PhoneNumb='#Evaluate("FORM.PhoneNumb" & Emp)#' Just a thought. HTH. ----- Original Message ----- From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 10:10 AM Subject: RE: Update multiple rows > thanks Steve > but that gives me this error: > i may just do all updates separately. > not sure > > ODBC Error Code = 22005 (Error in assignment) > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the > varchar value 'evaluate("FORM.PhoneID" & 1)' to a column of data type int. > > > -paul > > > > -----Original Message----- > From: Steve Oliver [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 11, 2002 12:23 PM > To: CF-Talk > Subject: RE: Update multiple rows > > > Whoops, should be > > SET PhoneNumb='evaluate("FORM.PhoneNumb" & #Emp#)' > WHERE tblPhone.EmpResID = '#FORM.EMPLOYEE_ID#' > AND tblPhone.PhoneID = 'evaluate("FORM.PhoneID" & #Emp#)' > > _____________________________ > steve oliver > senior internet developer > atnet solutions, inc. > http://www.atnetsolutions.com > > > -----Original Message----- > From: Steve Oliver [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 11, 2002 12:17 PM > To: CF-Talk > Subject: RE: Update multiple rows > > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
