Re: [plum] Roles on User List

[Jeff Fleitz]

Hi Jim, You need to have one custom query that the DisplayList tag can reference, which in this cases is a multi-table join between the PlumUser, PlumUserRole and PlumRole table. I think you are going to either have to use some loop processing or use a QoQ to distill the number of rows for each user to one beforehand, and then reference that query in the DisplayList tag and then add your DisplayColumnOnForm tag, if you want to use the Plum tag library for your form. Lots of processing going on there, just to get those roles up in a column.  Might be easier to just hand-build a PlumUserViewForm, and add a view link.  Or, if you have trouble with that, add a temp module and create your own dummy view form using the PlumUserTable. HTH, Jeff Jim Canup wrote: So Far I have this query at the top of my PlumUserList.cfm file (Just under the header comments). <cfquery name="GetUserRoles" datasource="#Application.dbDSN#" username="#Application.dbUsername#" password="#Application.dbPassword#">        SELECT  PUR.RoleName AS PUR_ROLENAME        FROM PlumUserRole PUR, PlumRole PR        HERE PUR.RoleCode = PR.RoleCode </cfquery> What I am wanting to do is display #ValueList(GetUserRoles.PUR_ROLENAME, ", ")# in another column in the UserList.  I cannot get it to work. I am not even sure how to get the query to work only for the user for that particular List Row. Jim From: Jeff Fleitz <[EMAIL PROTECTED]> Sent: Wednesday, April 13, 2005 2:52 PM To: plum@mail.productivityenhancement.com Subject: Re: [plum] Roles on User List What do you have so far? Should be able to do this by creating a custom query that includes the PlumRoles.RoleName column, and then identify the query you are using in the query attribute of the DisplayList tag. Is this what you are doing? Jeff Jim Canup wrote: I am desperately trying to hand-code a column to the Plum User List that will display a comma delimited list of the User's Roles. I am having no Luck at all!   Anyone want to offer a hand???   Jim Canup Application Security Engineer Digital Insight Two Midtown Plaza 1349 W Peachtree St Suite 1300 Atlanta, GA 30309 [EMAIL PROTECTED] tel: fax: mobile: 770-349-1267 678-969-7025 404-229-6562 Add me to your address book... Want a signature like this? ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************