<div>
Try creating a list from the loop and then adding the list to the query like:<br />
<br />
&lt;cfquery &nbsp;name=&quot;get_CIDS&quot; datasource=&quot;#request.dataS<wbr />ource#&quot;&gt;<br />
&nbsp; &nbsp; &nbsp; SELECT customerno, customer_first1, customer_last1<br />
&nbsp; &nbsp; &nbsp; FROM cibIDS<br />
&nbsp; &nbsp; &nbsp; WHERE customerno = &lt;cfqueryparam value=&quot;#customerno#&quot; maxlength=&quot;6&quot;&gt; AND<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CID IN (#loopList#) <br />
&lt;/cfquery&gt;<br />

</div>


Try creating a list from the loop and then adding the list to the query like:

<cfquery  name="get_CIDS" datasource="#request.dataSource#">
      SELECT customerno, customer_first1, customer_last1
      FROM cibIDS
      WHERE customerno = <cfqueryparam value="#customerno#" maxlength="6"> AND
            CID IN (#loopList#)
</cfquery>


<div>
Works great thanks for the quick help.
</div>


<div>
<div class="content wysiwyg-content">
Can I add the cfloop below to my cfquery statement?<br />
<br />
&lt;cfset counter=0&gt;<br />
&lt;cfloop index=&quot;i&quot; list=&quot;#CIDS#&quot; delimiters=&quot;,&quot;&gt;<br />
&lt;cfset counter=counter+1&gt;<br />
&nbsp; &nbsp; &nbsp; &lt;cfset &quot;CIDS#counter#&quot;=i&gt;<br />
&lt;/cfloop&gt;<br />
&lt;cfloop index=&quot;j&quot; from=&quot;1&quot; to=&quot;#counter#&quot;&gt;<br />
&lt;cfoutput&gt;#variables[&quot;CIDS<wbr />&quot; &amp;&nbsp;j]#&lt;/cfoutput&gt;<br />
&lt;/cfloop&gt;<br />
&lt;cfquery &nbsp;name=&quot;get_CIDS&quot; datasource=&quot;#request.dataS<wbr />ource#&quot;&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT customerno, customer_first1, customer_last1<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FROM cibIDS<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE customerno = &lt;cfqueryparam value=&quot;#customerno#&quot; maxlength=&quot;6&quot;&gt; AND<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CID =( How do I loop through the above cfloop and get the values to insert here?) <br />
&lt;/cfquery&gt;
</div>
</div>


Can I add the cfloop below to my cfquery statement?

<cfset counter=0>
<cfloop index="i" list="#CIDS#" delimiters=",">
<cfset counter=counter+1>
      <cfset "CIDS#counter#"=i>
</cfloop>
<cfloop index="j" from="1" to="#counter#">
<cfoutput>#variables["CIDS" & j]#</cfoutput>
</cfloop>
<cfquery  name="get_CIDS" datasource="#request.dataSource#">
	SELECT customerno, customer_first1, customer_last1
	FROM cibIDS
	WHERE customerno = <cfqueryparam value="#customerno#" maxlength="6"> AND
		CID =( How do I loop through the above cfloop and get the values to insert here?) 
</cfquery>

Loop a Query

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.