Updating multiple records at once.
Posted on 2006-05-09
I have a number of checkboxes on a field all have the same name: addedToSage. When multiple checkboxes are selected the output appears like this:
1,2,3,4,5,6,7,8,9,10 etc etc
Those are the ID's of the records I have outputted on the page.
What i'm trying to do is update each record by the ID listed in the outputted variable when someone hits submit.
So essentially what I need to do is this:
<cfquery name="updateRecords" dataSource="#dsl#">
addedToSage = "true"
WHERE ID = #FORM.addedToSage#
This doesn't work. So is it a case of using listLen and establishing the length of the addedToSage string and then using a loop to update each record in turn?
Thanks for you time