You're just going to have to write some logic to loop over the values that are a list.
On Fri, Nov 12, 2010 at 3:59 PM, Monique Boea <moniqueb...@gmail.com> wrote: > > 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:339167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm