> 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
