Hi,

I know I am a bit late in replying but I really want to try and get this working.

I have used your revised script and the portal is 0 so I used it as is. When I select run as script I get the following error:

System.Data.SqlClient.SqlException: Incorrect syntax near '.'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) SELECT Email, DisplayNameFROM dbo.[Users] U INNER JOIN dbo.[UserRoles] UR ON U.UserID = UR.UserID INNER JOIN dbo.[Roles] R ON UR.RoleID = R.RoleIDWHERE (RoleName = N'Newsletter') AND (R.PortalID = 0)

Thanks

Liz

sorry, this is a copy and past issue assumably caused by different encoding of the forums. please make sure to add a space after each line, thank you John for providing the corrected script.

Hi,

Any ideas on what happens to the results?

Thanks

Liz