Simon Reynolds - SimonReynolds.ie (Page 4)

SQL

Formatting a DateTime as text in SQL Server

I'm currently trying to display a Telerik Grid in an MVC view, one of the columns is a nullable DateTime2. The grid is using client side sorting as it doesn''t have to deal with large enough amounts of data to be worth implementing server-side sorting,

SQL

Building a string of subquery results in SQL

We have a table which includes a one-to-many relationship with some second table. Perhaps a person table which has a relationship to different email addresses associated with that person We want to build a query to return the person's name and the email addresses as a comma separated

MacOS

Installing Sass on OS X El Capitan

After recently upgrading to El Capitan I found that sass had been removed. No big deal, just reinstall it using sudo gem install sass What I wasn't expecting was the following error Fetching: sass-3.4.18.gem (100%) ERROR: While executing gem ... (Errno::EPERM) Operation not permitted -

.NET Core

Hosting an ASP.NET vNext application from NGINX

Note This entry has been updated and republished to account for the breaking changes which have taken place in the vNext (now DNVM) project and major updates to the post content regarding nginx configuration ASP.NET vNext includes its own web server, Kestrel, which can be invoked by running dnx

.NET Core

Install ASP.NET vNext on a DigitalOcean Ubuntu droplet

Note This entry has been updated and republished to account for the breaking changes which have taken place in the vNext (now DNVM) project .NET has gone open source! It''s now possible to build and run .NET applications on OSX and Linux. To install and run ASP

DateTime

Going on a date with javascript

First things first, the Date object in javascript is misnamed, it represents a date and a time. It should be DateTime instead but that's nowhere near the biggest issue. </pedantry> When dealing with dates there are a number of things to remember. Months are zero indexed,

JavaScript

Javascript and weakly defined types (Part 2: Electric Boogaloo)

Javascript and its lack of strong typing continues to cause headaches. Today's one is caused by the following bit of madness if (true) { alert("true evaluates as true"); // will show } if (false) { alert("false evaluates as true"); // will not show } if ('true'

The abstract keyword

It exists. If a class is only being used as a base class and will (or should) never be instantiated by itself, make it abstract. At the very least, if you start seeing compilation errors immediately you know that something isn't right.

Internet Explorer

Internet Explorer and button events

Filing this one under "Strange decisions that Internet Explorer makes", IE will assume that when a user hits enter in a textbox, they want to submit the form they are filling out. Normally this would be a reasonable assumption except for two problems; * IE does not check that

JavaScript

Javascript, isNaN and parsing

A word of warning with javascript and the magic of the isNaN function If we have an element such as <input type="hidden" id="myelement" value="(some optional value)" /> Then if myelement has a value of "1" <input type=

F#

Functional Programming in F#

Over the last year I have heard more and more about F#, a functional language for the .Net platform. A great resource for getting to know the language is F# for Fun and Profit What is Functional Programming? Imperative and Object-Oriented Programming (OOP) treat computation as a series of statements

C#

Parsing numbers in C based languages

In some C based languages such as C++, Java or Javascript any leading zeros at the start of a number will cause that number to be treated as octal (base 8). This peculiar issue can occur in templating or anything else where a text input will be treated as a