update tablename set formfield1 = <cfqueryparam value="#form.formfield1#" cfsqltype="cf_sql_varchar"> where formfield2 in <cfqueryparam value="#form.formfield2#" cfsqltype="cf_sql_integer" list="true">
On Fri, Mar 4, 2011 at 11:01 AM, Scott Williams <[email protected]>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:342752 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
