binki’s gists

binki / PHP Sort by Scripture (Bible)

Last active August 29, 2015 14:04 — forked from xeoncross/PHP Sort by Scripture (Bible)

	<?php

	function _scripturebooks() {
	return array("Genesis", "Exodus", "Leviticus", "Numbers", "Deuteronomy", "Joshua", "Judges", "Ruth", "1 Samuel", "2 Samuel", "1 Kings", "2 Kings", "1 Chronicles", "2 Chronicles", "Ezra", "Nehemiah", "Esther", "Job", "Psalm", "Proverbs", "Ecclesiastes", "Song of Solomon", "Isaiah", "Jeremiah", "Lamentations", "Ezekiel", "Daniel", "Hosea", "Joel", "Amos", "Obadiah", "Jonah", "Micah", "Nahum", "Habakkuk", "Zephaniah", "Haggai", "Zechariah", "Malachi", "Matthew", "Mark", "Luke", "John", "Acts", "Romans", "1 Corinthians", "2 Corinthians", "Galatians", "Ephesians", "Philippians", "Colossians", "1 Thessalonians", "2 Thessalonians", "1 Timothy", "2 Timothy", "Titus", "Philemon", "Hebrews", "James", "1 Peter", "2 Peter", "1 John", "2 John", "3 John", "Jude", "Revelation");
	}

	function scripturesort($a, $b) {
	if ($a == $b) {return 0;}
	$order=_scripturebooks();

binki / .sql

Last active August 29, 2015 14:08

	SET ANSI_NULLS ON
	SELECT a, b, CASE WHEN a!>b THEN 1 ELSE 0 END "a!>b", CASE WHEN a<=b THEN 1 ELSE 0 END "a<=b" FROM (SELECT 0 a, 0 b UNION SELECT 0, 1 UNION SELECT 0, NULL UNION SELECT 1, 0 UNION SELECT 1, 1 UNION SELECT 1, NULL UNION SELECT NULL, 0 UNION SELECT NULL, 1 UNION SELECT NULL, NULL) _;
	SET ANSI_NULLS OFF
	SELECT a, b, CASE WHEN a!>b THEN 1 ELSE 0 END "a!>b", CASE WHEN a<=b THEN 1 ELSE 0 END "a<=b" FROM (SELECT 0 a, 0 b UNION SELECT 0, 1 UNION SELECT 0, NULL UNION SELECT 1, 0 UNION SELECT 1, 1 UNION SELECT 1, NULL UNION SELECT NULL, 0 UNION SELECT NULL, 1 UNION SELECT NULL, NULL) _;

binki / gist:b841f5f5904109f6fc8f

Created November 2, 2014 05:28

initials output.txt

	NathanPhillip@dcxt540p ~/AeroFS/repos/initials
	$ /c/Program\ Files/JDK_64_bit/bin/java initials
	NNNN NNNNNN BBBBBBBBBB
	NNN NN BBBB BBBB
	NNN N BBB BBB
	NNNN N BBB BBB
	N NNN N BBB BBB
	N NN N BBB BBB
	N NNN N BBB BBB
	N NNN N BBBBBBBBBBB

binki / gist:ae2ddd809fdc73256b63

Created November 3, 2014 01:01

	ohnobinki@ohnopublishing ~ $ python
	Python 2.7.1 (r271:86832, May 14 2011, 10:43:48)
	[GCC 4.5.2] on linux2
	Type "help", "copyright", "credits" or "license" for more information.
	>>> range(0,2)
	[0, 1]
	>>> range(*[0,2])
	[0, 1]

binki / gist:556f2c90952739e7e3ae

Created November 3, 2014 01:21

	>>> def is_int(x):
	... try:
	... int(x)
	... return True
	... except:
	... pass
	... return False
	...
	>>> [int(x) if is_int(x) else x for x in 'asdf asdf 23'.split(' ')]
	['asdf', 'asdf', 23]

binki / fixed-precision.cxx

Last active August 29, 2015 14:08

	#include <sstream>
	#include <iostream>

	int main(int argc, const char *const argv [])
	{
	std::stringstream ss;
	ss.precision(2);
	int rounded_value = 4;
	ss << std::fixed << (double)rounded_value;
	std::string s = ss.str();

binki / output.txt

Last active August 29, 2015 14:09

Selecting multiple sublists that compose a more complex object in T-SQL

binki / Add to <Project> in.csproj

Created December 17, 2014 05:51

binki / gist:a4bc4b6bc0044798802c

Created December 30, 2014 19:36

binki / output

Created January 16, 2015 19:20

Returning 0 rows does not always mean NULL…

Nathan Phillip Brink binki