Ack! No, do not use listContains. listContains will match partial entries. Ie, if your list is:
ray,camden and you search for cam, listContains will return 2 while listFind will return 0. If your intent is to only match the item completely, use listFind (or listFindNoCase). ======================================================================= Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email : [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 06, 2003 9:21 AM > To: CF-Talk > Subject: RE: Comparing two listvars and deleting dups > > > Here's the solution I came up with... thanks for everyone's > help. Maybe this should be a UDF :) > > <cfset CurrentlyActiveUsers = "a,b,c,d,e"> > <cfset ExistingUsers = "b,d"> > <cfoutput> > <cfset newlist = CurrentlyActiveUsers> > <cfloop list="#CurrentlyActiveUsers#" index="x" delimiters=","> > <cfif ListContains(ExistingUsers, x, ",")> > <cfset newlist = ListDeleteAt(newlist, > ListFindNoCase(newlist, x, ","), ",")> > </cfif> > </cfloop> > > CurrentlyActiveUsers: #CurrentlyActiveUsers#<br> > ExistingUsers: #ExistingUsers#<br><br> > Cleaned List: #newlist#<br> > </cfoutput> > > -----Original Message----- > From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 06, 2003 10:06 AM > To: CF-Talk > Subject: RE: Comparing two listvars and deleting dups > > > Correct me if I'm wrong but that doesn't do what I'm asking. > > I want to remove all items in ListVar1 that appear in > ListVar2. They are not already duplicated in ListVar1. > > ~Jason > > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 06, 2003 10:01 AM > To: CF-Talk > Subject: RE: Comparing two listvars and deleting dups > > > http://www.cflib.org/udf.cfm?ID=532 > and > http://www.cflib.org/udf.cfm?ID=533 > > ============================================================== > ========= > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc > Member of Team Macromedia > > Email : [EMAIL PROTECTED] > Blog : www.camdenfamily.com/morpheus/blog > Yahoo IM : morpheus > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 06, 2003 8:55 AM > > To: CF-Talk > > Subject: Comparing two listvars and deleting dups > > > > > > Anyone have code off the top of their head to delete > > duplicate values from 2 lists. Here's an example. > > > > I want to delete all of the list items in ListVar1 that > > appear in ListVar2 > > > > ListVar1 = a,b,c,d,e > > ListVar2 = c,e > > > > Any suggestions? > > ~Jason > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
