Hello, In an application that I'm building I have a db table of users, and a table of company divisions. The users table has a DivisionID column that contains a comma delimited list of the Division IDs the user should have access to in the Application.
I know how to do a join to match up the Division Name to the user if the DivisionID column in users only contained a single DivisionID, but is there any way to do this with a comma delimited list of IDs? My goal is to be able to display the users in a cfgrid where the division column will contain a comma delimited list of the Division Names (not the Division IDs). Can I do this, or did I screw myself in the way I designed the app? Thanks, Jonathan ________________________________________________________ Jonathan Mauney Manager, Digital Media Properties / Web Application Developer 1110 WBT AM / 107.9 the LINK (WLNK-FM) / Jefferson-Pilot Radio Network Jefferson-Pilot Communications Co. One Julian Price Place Charlotte, North Carolina 28208 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
