I am using cold fusion and tSQL and trying to store multiple reasons and subreasons for a customer that is calling in with a SQL table from a table of checkboxes in coldfusion/html. There are about 16 subreasons and 5 reasons so I would rather not make separate fields for each. Currently my SQL table has data and I can display it, but I have not been able to write a query to update or insert the data from checkboxes.
My SQL table fields are:
where the log_id associates the various reasons and subreasons for the contact. The reason_id and subreason_id's come from tables with the various reasons and subreasons in them.
When displaying the output I am able to use nested cfloops to display all the data in a table and then i check if the SQL table has a matching column and row to display the check.
Even if I could get an insert to work with this I am having a hard time thinking of ways you can do an update if the data needed modified. Any advice would be appreciated and if you need more information please let me know.