Looping an array

Coder76 wrote: I'm trying to loop an array inside another loop and am running into an issue.  The problem is that the inside loop works but it is looping the outisde loop x number of times

Well you are getting exactly what you have coded.

Your output is inside the inner loop, so it is going to output something every time.  The fix that is most similar to what you have already coded would be to set a flag inside the inner loop and do your output in the outer loop.

<CFLOOP QUERY="GetProductList">
    <cfset checked = "NO">
    <CFLOOP index="VPU" from="1" to="#ArrayLen(myList)#">
        <CFIF PID EQ myList[VPU]>
            <cfset checked = "YES">
        </CFIF>      
    </CFLOOP>   
    <CFINPUT NAME="SKUName" TYPE="checkbox" VALUE="#PID#" CHECKED="#checked#" />#SKUName# <br />
</CFLOOP> 

But there are other ways to do this that would involve less lines of code using some of the list functions.

http://livedocs.adobe.com/coldfusion/8/htmldocs/functions-pt0_13.html

I think this would produce the same output.

<cfset myList = ValueList(AccountProducts.PID)>
<CFLOOP QUERY="GetProductList">
    <CFINPUT NAME="SKUName" TYPE="checkbox" VALUE="#PID#" CHECKED="#yesNoFormat(listFind(myList,PID))#" />#SKUName# <br />
</CFLOOP>