Are you doing the update via a SQL statement or stored proc? On Fri, Mar 4, 2011 at 11:01 AM, Scott Williams <myscottwilli...@yahoo.com>wrote:
> > 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:342753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm