Duncan Angus Wilkie MRdNk

In 'git bash'

mkdir behave && cd behave
git init
git pull https://github.com/jakiestfu/Behave.js.git master

Copy behave.js, into your local project.

C# List delegate

A delegate allows you perform an action on a list type, FindAll - returns a new list, based on the conditions you put into the delegate.

List<KeyValueBool<int, String>> list = disp.List.FindAll (delegate (KeyValueBool<int, string> kvb) {
  return kvb.Boolean == true;
});

DataTable

var DataTable = function (opts) {
  this.columns = [];
  for (key in opts) {
    if (opts.hasOwnProperty(key)) {
      // this.columns.push (opts[key]);
      this.columns.push (opts[key]);

Table event listener

var stmt = sql.query(conn_str, "SELECT * from tbl1");
stmt.on('table', function (table) {
  console.log('table', table);
})

An alternative to doing C# List Delegates (https://gist.github.com/4654896) is to use a Predicate / Lambda Expression...

private List<KeyValueBool<TKey, TValue>> _list;

public Boolean Exists (TKey ID) {
  return _list.Exists (item => EqualityComparer<TKey>.Default.Equals (item.Key, ID));
}

public TValue GetValue (TKey ID) {

-- DATE ONLY ELEMENT
SELECT DATEADD(dd, 0,DATEDIFF(dd, 0, GETDATE()))

-- DATE TO NEAREST MINUTE
SELECT DATEADD(mi, DATEDIFF(mi, 0, GETDATE()),0)

-- CONVERT TO TIME as Varchar
SELECT CONVERT(VARCHAR(5), GETDATE(), 108)

	var sqlParams = [];

	var forenameParam = {
	name: '@forename'
	, type: 'int'
	, value: 'Bob'
	}

	sqlParams.push(forenameParam);

	{
	"name": "Demo",
	"version": "0.0.0",
	"description": "description",
	"main": "app.js",
	"directories": {
	"test": "test"
	},
	"dependencies": {
	},

	GO
	/**** Object: UserDefinedFunction [dbo].[fnIsSameDate] Script Date: 02/12/2013 17:02:41 ****/
	SET ANSI_NULLS ON
	GO
	SET QUOTED_IDENTIFIER ON
	GO
	-- =============================================
	-- Author: Duncan Angus Wilkie
	-- Create date: 12/02/2013
	-- Description: Do datetime (DATE only) match?

	ISNUMERIC(zipcode + '.0e0') --integer
	ISNUMERIC(zipcode + 'e0') --decimal