<cfset match = 0>
<cfloop list="#listA#" index="i">
    <cfif listFind(listB, i)>
        <cfset match = 1>
    </cfif>
</cfloop>

HTH!

Sharon DiOrio

----- Original Message ----- 
From: "Won Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 21, 2002 1:57 PM
Subject: Most efficient way to check if two lists


> Hello,
> 
> Need to find out which way is the most efficient way to see if a value in
> list A is a value in list B.
> 
> List A = 1,2,3 VALID ListMatch
> List B = 2,3,4
> 
> List A = 1,2,3 VALID ListMatch
> List B = 1,4,6
> 
> List A = 1,2,3 NOT VALID ListMatch
> List B = 7,4,6
> 
> 
> As long as it has single matching values it is valid.
> 
> 
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to