Hi guys, I've got a database column which is currently storing comma seperated values (i.e. 1,2,3,4 etc.). What I'm trying to do is compare each seperate value to another database column which also has seperated values (i.e. 7,8,9,10). I'm not sure how to parse those values so CF compares each individual one. Right now it seems like it's just comparing the first value, or maybe the whole combination but not going through each value in sequence to see what matches.
My question is, do I have to pull the data from the columns, set up an array, use the ArrayToList function, then have it compare? Is it easier to just have the query filter it initially? If so, what is the best approach? Thanks! :) -Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54