<div>
<div class="content wysiwyg-content">
I have a table that I need to clear values first then update it with correct data. It needs to happen 3 times. For some reason it's only happening once. 
Please see code below: 
 
&lt;cfquery name=&quot;updateFeaturedCourse&quot; datasource=&quot;#application.dsName#&quot; username=&quot;#application.dsUserName#&quot; password=&quot;#application.dsPassword#&quot;&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UPDATE courses 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET featuredcourse = 'N', featuredcourseordernumber = 0 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE featuredcourse = 'Y' 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfloop from=&quot;1&quot; to=&quot;3&quot; index=&quot;ThisRow&quot;&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!--- extract each value ---&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;UPDATE courses 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET featuredcourse = 'Y', featuredcourseordernumber = '#Evaluate('form.hcf_#ThisRow#')#' 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE courseid ='#Evaluate('form.hf_#ThisRow#')#' 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfloop&gt; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/cfquery&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cflocation url=&quot;set_featured_courses.cfm?aid=m&quot; addtoken=&quot;no&quot;&gt;
</div>
</div>

I have a table that I need to clear values first then update it with correct data. It needs to happen 3 times. For some reason it's only happening once.
Please see code below:

<cfquery name="updateFeaturedCourse" datasource="#application.dsName#" username="#application.dsUserName#" password="#application.dsPassword#">
				UPDATE courses 
				SET featuredcourse = 'N', featuredcourseordernumber = 0 
				WHERE featuredcourse = 'Y'
 <cfloop from="1" to="3" index="ThisRow">
				
 	UPDATE courses 
 	SET featuredcourse = 'Y', featuredcourseordernumber = '#Evaluate('form.hcf_#ThisRow#')#'
 	WHERE courseid ='#Evaluate('form.hf_#ThisRow#')#'
				</cfloop>
 </cfquery>
			<cflocation url="set_featured_courses.cfm?aid=m" addtoken="no">

Update sql table using coldfusion query and loop

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.

Web Servers

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.