FIELD1: I have the following string in a db field: 1,2,3,4,5,6,7,8,9,10,11,12
FIELD2: I have another string in another field: 2,3,4,7,10,11,13
I am using FIELD1 with the following code to display 12 checkboxes. I am displaying a page that lists all FIELD1 numbers as checkboxes. As the user checks the available checkboxes and submits the form, I am inserting the selected checkboxes into FIELD2.
I am now trying to setup an update web form that will display all available numbers from FIELD1 and check those boxes if they are contained in FIELD2.
I have attached a screen shot, so I hope that helps.
Also, I have attached my code, since I am having trouble displaying it here in the comments... I am using the cfloop through FIELD1 to display all the checkboxes.
Comment: The database field is in the following format 1,2,3,4,5 and I am using numberformat to display at 001,002,003,004 ect...