Hello all -- I have a form that contains checkboxes which sends multiple record numbers to an action form for processing. For example, it would send:
formfield1="ABC" formfield2=1,2,3,4,5,6,7 In the database I want to update the formfield1 column to ABC wherever the formfield2 column value is either 1 or 2 or 3 or 4 or 5 or 6 or 7. I've tried a few different ways to do this, but only one record gets updated. Any tips on how I can accomplish this? Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm