RE: [plum] Roles on User List

[Jim Canup]

Here is my latest attempt at modification of the PlumUserList.cfm file. The code inside the box is my new code:       <!--- The third column will display the user's email address --->       <cf_DisplayColumnInList column="Email" label="Email">           <!--- The fourth column will display a comma delimited list of the user's roles --->       <cf_DisplayExpressionInList label="Roles">                  <cfquery name="REQUEST.GetUsers" datasource="#Application.dbDSN#">                   SELECT      PR.RoleName AS Roles                                        FROM       PlumUserRole PUR, PlumRole PR                   WHERE       PUR.RoleCode   = PR.RoleCode                               AND PUR.UserID = #PlumUser_UserID#             </cfquery>             #ValueList(REQUEST.GetUsers.Roles, ", ")#             </cf_DisplayExpressionInList>             <!--- The last column will contain links to the Add, Edit, and Delete forms --->       <cf_DisplayListLinks add="Yes" view="No" edit="Yes" delete="Yes">         I am getting the following error:      Variable PLUMUSER_USERID is undefined. I have tried caller, attributes, request, etc. and I cannot seem to use #PlumUser_UserID# inside the Query. I can use it outside the query just fine, but not inside.  I am stumped!!!   Jim       -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff Fleitz Sent: Wednesday, April 13, 2005 3:59 PM To: plum@mail.productivityenhancement.com Subject: Re: [plum] Roles on User List   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 **********************************************************************