update db table with list
Posted on 2011-03-22
I have the following query and am trying to loop through this list and update the column with each value but it's not working. So each value in the list needs to be updated in each row in the table. Any ideas what I'm doing wrong?
<cfset newUrlList = '1,2,3,4,5">
<cfloop list="#newUrlList#" index="curLine">
<cfquery name="updmarker" datasource="dsn">
set marker = '#curLine#'