Even better - thanks Dave! Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ *************
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 11:30 PM To: CF-Talk Subject: RE: Update Multiple Records With One Query > Try this for your UPDATE routine (adding your remaining > fields as needed): > > <cfloop index="Indx" from="1" to="#Form.RowCount#"> > > <cfquery datasource="#dsn#" name="update"> > UPDATE attendee SET > assigneddate ='#evaluate("form.assigneddate#Indx#")#', > attended = '#evaluate("form.attended#Indx#")#' > WHERE users_id = #evaluate("form.ID#Indx#")# > </cfquery> > > </cfloop> Just to nitpick, you don't need to use Evaluate here, and you don't need so many hashes: ... SET assigneddate = '#Form["assigneddate" & Indx]#', ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4