<http://www.cflib.org/udf.cfm?ID=169>
And you may also want to look at <http://www.cflib.org/udf.cfm?ID=149> Two things to make note of. Arrays and structures are considered to be more efficient than lists. If you are going to have 500 list elements, I might question whether a list is the best way to perform You said you were going to have a big list, and then went on to refer use the term records, which usually refers to a query result set. If you are going to be comparing two separate queries, it probably would not make sense to convert the query to a list for further processing. Deal with it as a query. At 01:17 PM 12/16/2002 -0500, you wrote: >Hi everyone. I am looking for a way to compare 2 different lists of >information, and after comparing them keep which records are exactly the >same. Does anyone have any suggestions on how to do this? This list have the >potential of being pretty big (500 records each) and I was hoping to have >this process done fairly quick (so the user doesn't have a long wait). Any >help you can provide with this problem is greatly appreciated. Thanks very >much. >Keith -- Jeffry Houser | mailto:[EMAIL PROTECTED] DotComIt, Putting you on the web AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: <http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20> My Books: http://www.instantcoldfusion.com Original Energetic Acoustic Rock: http://www.farcryfly.com 80's, 90's, and Now: http://www.mtmexperience.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
