Replace Null or Empty Value with String

posted on September 16, 2014 06:28

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

Posted in: SQL Scripts, SQL Server 2008 R2, Stored Procedures

Actions: E-mail | Permalink | Comments (0)

02

DNN 404 Errors on IIS 7 using ApplicationPoolIdentity

posted on September 02, 2014 08:17

Solved on IIS7.Issue is in the web config the <modules tag needs to be changed to the following: <system.webServer> <mod...

[Read the rest of this article...]

DNN, IIS 7

Posted in: DNN, Web.Config

Actions: E-mail | Permalink | Comments (0)

06

DNN GetUsersByRoleName for a Dropdown

posted on July 06, 2014 07:56

public void GetPreviousAgents(string _AgentRole) { try { DotNetNuke.Security.Roles.RoleController objRoleController = new DotNetNuke.Security.Rol...

[Read the rest of this article...]

DNN, GetUsersByRoleName, C#

Posted in: C Sharp - C#, DNN, Modules, Custom Modules

Actions: E-mail | Permalink | Comments (0)

27

Fixed Cover Background Image

posted on June 27, 2014 06:14

#Body { background-image: url(/Portals/2/bg1.jpg);background-size: cover !important; background-attachment: fixed;}

Posted in: CSS, DNN

Actions: E-mail | Permalink | Comments (0)

24

Hyperlink a Telephone Number

posted on June 24, 2014 10:11

Area code with dashes, 1 and + sign <a href="tel:+1-555-555-1212">555-555-1212</a> Hyperlink Phone Number

Posted in: Web Design

Actions: E-mail | Permalink | Comments (0)

24

DNN Registration of jQuery and Plugins in DotNetNuke

posted on June 24, 2014 08:53

protected override void OnInit(EventArgs e) { base.OnInit(e); JavaScript.RequestRegistration(CommonJs.jQue...

[Read the rest of this article...]

Posted in: DNN, Modules, Custom Modules

Actions: E-mail | Permalink | Comments (0)

14

Delete Spam Registrations

posted on June 14, 2014 08:56

UPDATE UserPortals SET IsDeleted = 1 WHERE (UserId > 5) SQL Script

Posted in: DNN

Actions: E-mail | Permalink | Comments (0)

12

COALESCE (Transact-SQL)

posted on May 12, 2014 14:11

COALESCE (Transact-SQL)

Posted in: Microsoft SQL Server, SQL Scripts

Actions: E-mail | Permalink | Comments (0)

12

stop fading on hover in edit mode

posted on May 12, 2014 07:52

/*stop fading on hover in edit mode*/ .dnnEditState .DnnModule { opacity: 1.0; }

Actions: E-mail | Permalink | Comments (0)

22

Server.MapPath Usage

posted on April 22, 2014 08:51

Server.MapPath specifies the relative or virtual path to map to a physical directory. Server.MapPath(".") returns the current physical ...

[Read the rest of this article...]

Posted in: C Sharp - C#

Actions: E-mail | Permalink | Comments (0)

Snippets