CREATE FUNCTION GIBS_GetProfileElement ( @userID as int, @portalID as int, @ProfilePropertyName as nvarchar(100) ) RETURNS nvarchar(4000) AS B...

[Read the rest of this article...]

UPDATE PortalSettings SET SettingValue = 'False' WHERE SettingName = 'EnablePopUps' DNN Popup Windows

UPDATE YourTable SET YourColumn = RTRIM(LTRIM(REPLACE(REPLACE(YourColumn, CHAR(10), ''), CHAR(13), '')))

-- Used this great tool (https://github.com/FabioParigi/NBrightBuyMigrate ) but ran into a problem with images -- Create a SP to verify the old strin...

[Read the rest of this article...]

SELECT        UserID, Username, FirstName, LastName, IsSuperUser, AffiliateId, Email, DisplayName, UpdatePassword, ...

[Read the rest of this article...]

DNN Users

  (SELECT [Value] FROM Lists where EntryID = (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT ...

[Read the rest of this article...]

DNN Region Lookup