Re: Using a Listbox to allow Users Access
Depending on how you have your validation structured for permissions, an idea would be: Session.CompanyAccess = '1,2,5,6' Then you can validate it when needed. Now if you are going further to set permissions such as CRUD: Session.CompanyAccess.Permissions_1 = C,R,U,D Session.CompanyAccess.Permissions_2 = R Session.CompanyAccess.Permissions_3 = C,R,U (CRUD = Create, Read, Update, Delete) On Mon, Sep 28, 2009 at 6:01 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Hi, I have a drop down list on a form showing a list of Companies, which ive linked to a table called Company, Im trying to use this list to give access for each username, at them min when someones name is added to the Table (Users) they have access to all Companies on the list box, im trying to change this so i can give each person access to only the companies I require Can someone help me out on how I go a bout doing this? Thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using a Listbox to allow Users Access
Thanks, The first option will suit me so if i set up a field in My Users table called CompanyAccess, then followed by the correct code it will be able to pick out wheather or not I can access it depending which numbers I have entered in my CompanyAccess field Depending on how you have your validation structured for permissions, an idea would be: Session.CompanyAccess = '1,2,5,6' Then you can validate it when needed. Now if you are going further to set permissions such as CRUD: Session.CompanyAccess.Permissions_1 = C,R,U,D Session.CompanyAccess.Permissions_2 = R Session.CompanyAccess.Permissions_3 = C,R,U (CRUD = Create, Read, Update, Delete) On Mon, Sep 28, 2009 at 6:01 AM, Damo Drumm damien.dr...@quinn-group.comwrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using a Listbox to allow Users Access
Yes, however you will need to validate permissions when needed Ex: CFIF ListFind(Session.companyAccess,thisCompanyID) ... GOOD CFELSE ... BAD /CFIF On Mon, Sep 28, 2009 at 7:14 AM, Damo Drumm damien.dr...@quinn-group.comwrote: Thanks, The first option will suit me so if i set up a field in My Users table called CompanyAccess, then followed by the correct code it will be able to pick out wheather or not I can access it depending which numbers I have entered in my CompanyAccess field Depending on how you have your validation structured for permissions, an idea would be: Session.CompanyAccess = '1,2,5,6' Then you can validate it when needed. Now if you are going further to set permissions such as CRUD: Session.CompanyAccess.Permissions_1 = C,R,U,D Session.CompanyAccess.Permissions_2 = R Session.CompanyAccess.Permissions_3 = C,R,U (CRUD = Create, Read, Update, Delete) On Mon, Sep 28, 2009 at 6:01 AM, Damo Drumm damien.dr...@quinn-group.com wrote: ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4