Jillian, I looked over your code and notice you have your update query on the same page as your form, yet your form's action page is set to "grading.cfm?id=#courses.id#." If you move that chunk of code to grading.cfm, all should work fine...and you shouldn't need to use url.action or form.action variables.
BTW, just to be on the safe side, *all* of the form parameters used in your update query should be wrapped with CFQUERYPARAM...but you already have a good start on that. ~Dina ----- Original Message ----- From: "Joshua Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 13, 2003 10:32 PM Subject: RE: Update Multiple Records With One Query > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
