Installed 1.1.8 on DNN 5.04.01

May 10, 2010 at 4:00 PM
Found out about this by searching for DNN within Visual Studio Extension Manager. I REALLY appreciate the nice welcome page and sample page on CodePlex - most projects here seem to errantly assume visitors know what their tool does and how to use it! Installed version 1.1.8 on DNN 5.04.01 without issue just now. I'm hung up on how to create the stored proceedures in your 'Getting Started' section, but think your approach and documentaiton is superb!
Coordinator
May 10, 2010 at 4:41 PM
Edited May 10, 2010 at 4:42 PM

Hello,

Script can be executed "as is" on Host/SQL page. Just copy it there, check "Run as Script" and click "Execute".

Or you can replace {databaseOwner}[{objectQualifier} with your prefix name and execute script from SQL Server Management Studio directly. I assigned a "dnn" prefix, so my script is

create procedure dbo.[dnn_mdo_xslt_users] @PortalID int as
begin
   select * from dbo.[dnn_UserPortals] up
   join dbo.[dnn_Users] u on u.UserID = up.UserID
   where up.PortalID = @PortalID;
end;

HTH,

Anton.