OK But isnt that what this query is achieving ? Getting a list if a users permissions for a group ??
<cfquery datasource="perm" name="qryGetUserGroupsPerms"> SELECT users.id AS "userid", users.fname, users.lname, users.username, users.password, users.email, users.position, users.division, groups.groupname, permissions.permname, userpermissions.groupid, userpermissions.permid FROM (( users INNER JOIN usergrouppermissions AS userpermissions ON users.id = userpermissions.userid) INNER JOIN permissions AS permissions ON userpermissions.permid = permissions.permid) INNER JOIN groups AS Groups ON userpermissions.groupid = groups.groupid WHERE (((users.id)=#session.id#)); </cfquery> ----- Original Message ----- From: "Stephen Moretti" <[EMAIL PROTECTED]> To: "Ian Vaughan" <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 3:41 PM Subject: Re: Why is this not working the way it should ??? > > > > Just tried what you suggested but it looked like img.gif attached when it > > should be looking like img2.gif attached. > > > > Is this possible to achieve ???? If so any idea of what changes need to > be > > made to the code ?? > > > Yes. > > You need to get a list of the permissions for a group and output them as the > options of the drop down using the information from the > qryGetUserGroupsPerms to select the appropriate permission for the group. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
