Last post Jan 31, 2006 10:47 AM by PScarlett
Jan 29, 2006 07:23 PM|K-FleX|LINK
Does anyone know how i can extract the First Name, Last Name and email address from my DNN Database of anyone registered? I need to do a mass email to my customers through another marketing program. How do i run an SQL query?
Jan 31, 2006 10:47 AM|PScarlett|LINK
U.username = au.username
and au.Userid = m.UseriD
and au.Userid in (select UserID from aspnet_UsersInRoles
where RoleID = (select RoleID from dbo.aspnet_Roles where LoweredRoleName = 'registered users'
and applicationid = (select applicationid from aspnet_applications where applicationname = '0')
The applicationname = '0' relates to the portal. So change it as required. Since all users are registered unless removed from the role, the and clause with UserID from UsersInRoles may be overkill..