Hello, Is there any way of using tokens associated with specific users, not only the user who is currently logged in? Instead of [User:Email], I would like to have [John:Email], for example. The reason I want this is that I would like to have a dynamically updated E-mail list on my site, so that when a user changes his email-adress, the list changes accordingly. Maybe there is another way of accomplishing this? Thanks for any advice, Knut Erik

If you want to create a list of users with their email addresses, I'd recommend using the Reports module. It will build the list dynamically whenever you visit the page that contains it.

Joe, Thanks. I'm new to SQL. Would you happen to know what I should write in the query field to list Display Names and Email addresses for all users in a specific role? I have figured out how to do this for all the users, but not when I want just those who are members of a specific role. I would also like to sort the users alphabetically by Display Name, if that is possible. Thanks for your help, Knut Erik

I use this for selecting username, first, last name, email, role id and role name

SELECT Users.UserID, Username, FirstName, LastName, Email, UserRoles.RoleID, Roles.RoleName
FROM         Users INNER JOIN
                      UserRoles ON Users.UserID = UserRoles.UserID INNER JOIN
                      Roles ON UserRoles.RoleID = Roles.RoleID
WHERE     (UserRoles.RoleID = 3)

You will see the where clause is where Role id = 3, this is the newsetter security role on my site, you will need to look at the Roles table to see the id for the RoleName you require.

Or alternatively, just run the query and keep changing the roleid number until you find the correct one as it will display the role name in the results

ps. you may want to check out these tutorials:

• Introduction to SQL Queries with SQL Server Express, DotNetNuke and Vista
• SQL Queries for Exporting DotNetNuke Users and Working with Security Roles
• Working with Shadow / Copied Modules and SQL in DotNetNuke
• How to Update the DotNetNuke Page Settings Using SQL Queries
• Administrating modules in DotNetNuke using SQL
• Administrating Skins and Containers using SQL
• How to Quickly Add Large Quantities of Data into DotNetNuke Modules

Fantastic! Just what I needed. You saved me a lot of time, as I am in a hurry to finish this before I leave on vacation. You have been very helpful. Thank you so much.