troubleshooting Question

Update multiple records from a list

Avatar of earwig75
earwig75 asked on
ColdFusion Language
2 Comments1 Solution200 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
gdemaria

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros