When getting the information out of the database, us distinct on the field.
-- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Thu, May 3, 2012 at 2:37 PM, Les Mizzell <[email protected]> wrote: > > Got an app that sends out email to various lists - CF8 > > I'm checking to be sure there are any duplicates between the two lists > > req.this list - usually pretty small - ten or so email addresses > req.groupLIST - is the problem - it could be a500 or more addresses at > times. > > <cfloop list="#req.thisLIST#" index="i"> > <cfif NOT listfindnocase(req.groupLIST,#i#)> > DO MY STUFF HERE > </cfif> > </cfloop> > > Is there a more efficient way to do the above? If req.groupLIST ends up > being a HUGE list - at what point will this choke down and time out? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:350970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
