Replace the commas on the select value with a different delimiter. Then un-replace them when you insert into the db. As an aside, it just about always works out better to create a relational table for this kind of data.
-----Original Message----- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 7:42 AM To: CF-Talk Subject: Array from multi-select I'm working with a multi-select field. Some of the elements have commas in them. When I go to add them to a database and I check the form element, it delimits them with commas with no difference between those and content commas. When go to repopulate the multi-select field and break the db information into an array, the content commas produce the effect of having too many or extra elements. (ie athletic, training becomes two elements). Excepting a relational table is there another way to deal with this? thank you. -- Daniel Kessler University of Maryland College Park School of Public Health Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
