Paul Ihrig wrote: > ian, that is exactly what i am doing. > but i am storing a list inside a column to refer to user created groupings > of items.
Ok, this would be fairly easy to normalize with a join table. user_grouping -------------- userID groupID Then you would have records something like iskinner 135 jblow 132 pIhrig 135 pIhrig 132 Your query would then work exactly as you want it to. Without the modification to your database you are not going to be able to get these results. You are going to have to finish the processing in your CFML. One of the easiest ways would be to convert the valueList() resutls to a structure which would consolidate all duplicates then retrieve the list again with structKeyList(). But if you have a choice, normalizing your database is much more flexible and scalable. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
