Clear all page level skins in a Portal update {databaseOwner}{objectQualifier}Tabs set skinsrc=null where SkinSrc is not null and PortalID=0   ...

[Read the rest of this article...]

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

[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 string...

[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 P...

[Read the rest of this article...]

DNN Region Lookup

Declare @PortalId int; Set @PortalId = 0; SELECT 'OwnerFirstName' = U.FirstName, 'OwnerLastName' = U.LastName, 'OwnerEmail' = U.Email , (SEL...

[Read the rest of this article...]

DNN Region Lookup SQL

I had a need for getting a property details for a SSR report and came up with the following store procedure  . . . I thought it might be useful t...

[Read the rest of this article...]

Ventrian Property Agent

Select ISNULL(NULLIF(GIBS_FBLineItems.ReportType, ''), '--Undefined--') as ReportType from GIBS_FBLineItems SQL