Yes, each department about 6 in total -----Original Message----- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 22 December 2004 10:25 To: CF-Talk Subject: Re: ColdFusion built-in tags and permission-based security framework
Ian Vaughan wrote: >How could I display the correct menu options which are generated from the correct cfquery based on the user logged in. > >So if the user logged in is from the personnel department the following query populates the select boxes, but if the user logged in is from the finance department then the finance query runs on the page to populate the select box. > >Can anybody see any flaws with this approach ? Or how it can be improved to make the solution more flexible? > > Ian, Are you saying that you have a separate category table for each department? Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188511 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
