Update multiple records from a list
Posted on 2014-08-14
I have a text field and some checkboxes. When the form is submitted the check boxes create a list. The field is called "selected". So, After the form is submitted I have a 2 fields, one is a list of numbers(selected) like this 3,7,9,10 and a value from the text box "car",
The values from "Selected" are the IDs from each record i would like to update. So, if the boxes 5,6,7 were checked I want to update records with ID 5,6,7 with the value from the text box.
Could someone assist with this? I'd like to avoid having a query in a loop. Thank you.