Never mind -- I figured it out. This works: <cfquery name="query2" datasource="#dsn#"> UPDATE aTable SET ColumnA = '#form.var1#' WHERE ColumnB IN (#form.var2#) </cfquery>
I had tried using IN in my update query except that I didn't include the parentheses. 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:342754 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm