> When getting the information out of the database, us distinct on the field.
Only one list is coming from the database, the other is from a completely different source. > convert your list to an array and loop over that The small list is the one that will have the operations done to it. The large list is the one that I need to search for duplicate values. If the server was running CF9 then I could use ArrayFind but that's not available in CF8. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
