Hello All. I'm pretty sure that this is something very simple and I am over thinking it but here is my issue:
I have a form with dynamically created input boxes one of which can be a checkbox. When the user submits the form, of course the checkbox field is submited as one, but with 2 values (see fields/value below) (The blue text is the form fields, the red is values). 4454 16829 4455 27788 4456 16699,16700 8436 52246,52247 When I insert these recods into the DB, they must be inserted as integers, so of course the comma causes an error. How can I separate these values and have them inserted as two seperate columns? So the above would look like this: 4454 16829 4455 27788 4456 16699 4456 16700 8436 52246 8436 52247 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
