Re: [plum] Roles on User List

[Jim Canup]

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 **********************************************************************