I have a CFSELECT box that allows multiple choices. I want each choice to be a new record in a table. The CFSELECT separates the choices by commas when you submit. Can someone help with the correct way to write the query for this insert and update?
I understand it's not a good practice to have a query within a loop, so I'm trying to avoid that. Thank you.