Hi Jason, If you've got the time, it would be interesting if you could post some excution times for each method.
What size list are you talking about? Cheers David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Monday, 10 January 2005 11:59 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Removing duplicates from a list You could use a query of query aswell if you wanted to, still using the udf method but using cffunction <cffunction name="removeDuplicates"> <cfargument name="list" required="Yes" /> <cfscript> var qList = queryNew(""); var qColumn = listToArray(arguments.list); var qReturn = ""; queryAddColumn(qList, "list", qColumn); </cfscript> <cfquery dbtype="query" name="qReturn"> SELECT DISTINCT(list) AS listItem FROM qList </cfquery> <cfreturn qReturn /> </cffunction> <cfdump var="#removeDuplicates('test,hello,bla,test,smile')#"> The only thing using this way is that the query qill sort the list so you wont get it back in the same order as you passed it in. manually you can do this. The query will be heaps faster then sorting, storing, loop and the rest of it with the normal UDF method. Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Sheedy Sent: Monday, January 10, 2005 11:46 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Removing duplicates from a list Thanks for the tip David. The udf uses the same technique that I'm currently using.. i.e. loop over the list and use listFind to remove duplicates. The reason I'm looking for a simpler method is to reduce processing time for large lists. Encapsulating it in a udf is handy though .. Jason Sheedy Senior Web Developer Voice International Limited www.voice.com.au -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Whiterod, David (DTUP) Sent: Monday, 10 January 2005 10:20 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Removing duplicates from a list Hi Jason Case-sensite: http://cflib.org/udf.cfm?ID=532 Case-insensitive: http://cflib.org/udf.cfm?ID=533 Cheers David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Sheedy Sent: Monday, 10 January 2005 10:23 AM To: CFAussie Mailing List Subject: [cfaussie] Removing duplicates from a list Hi guys and gals, does anyone know an easy way to remove duplicates from a list? With all the handy list functions built into cf I would have thought this one would be a must. Jason Sheedy www.voice.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ b?\&v}?'?y z{jW?&i?Gj)Wj Cu?wx v&z?? uw --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
