Most efficient probably depends on how the list is organized, but check out cflib and the ListInCommon or ListUnion udfs. You could probably modify one of them to just return true as soon as a match was found instead of building the entire union.
</rob> -----Original Message----- From: Won Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:57 PM To: CF-Talk 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. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
