[EMAIL PROTECTED] wrote: > > 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?
You can probably still do this if you are willing to invest the effort. But I would suggest normalizing you data and using a separate table to maintain the relations between users and divisions. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
