Ian, > <input type="checkbox" name="groupid" value="#getgroups.groupid#" <cfif getgroups.GroupID IS getgroups.groupid> checked</cfif>> > In the cfif in your input box your comparing the groupid from your query against itself, so its always going to return true. If qryGetUserGroupsPerms is the query that gets the groups and permissions that a user has then you perhaps want something like this.
<cfset GroupIDList = valueList(qryGetUserGroupsPerms.groupid)> <cfif ListFind(GroupIDList,getgroups.groupid) gt 0> checked</cfif> > > <option value="#getgroups.PermID#" <cfif qryGetUserGroupsPerms.PermID > IS getgroups.PermID>selected</cfif> >#getgroups.PermName#</option> > You're looking at something similar here, but its more complex because you have to take into account that you have all the permissions for all the groups that a user belongs to. I think it might be worth trying to simplify what you're trying to do in the first instance. Rather than trying to display all the groups that a user belongs and the permissions for each group, just try displaying one group and the permissions for that user in that group. Once you've got that working, then you should be able to use what you have to build something that will display all the groups and the permission for each group. Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
