Re: [plum] Roles on User List

[Jeff Fleitz]

I forgot to mention that one way to do it is just create your own empty query with QueryNew() and build it from scratch, row by row.  Then reference the result with the query attribute of the DisplayList tag. 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 **********************************************************************