nathany

select 	PT.FacID, f1.FacName, [1] as QtyAlloc, [-1] as QtyUsed, [1] + [-1] as QtyRemain
from
(
		select 	f1.FacID, sign(f1.Quantity) as Sgn, f1.Quantity
		from 	FacCredits f1
) as q1
pivot
(
		sum(q1.Quantity)
		for q1.Sgn in ([1], [-1])

nathany

/* Pure CSS tool tips from CSS Mastery, originally by Eric Meyer? With fix for IE, see below */

a.tooltip {
	position: relative;
}

a.tooltip span {
	display: none;
}

nathany

;; reference to a set (unique) visitors
(def visitors (ref #{}))

(defn hello 
  "Writes hello message to *out*. Calls you by username.
  Knows if you have been here before."
  ([] (hello "world"))   ; with no arguments
  ([username]
  (dosync
    ;; deref visitors, call username to see if it's there

nathany

// Returns the index of the first character contained in searchChars 
// From Apache Commons Lang, http://commons.apache.org/lang/
public static int indexOfAny(String str, char[] searchChars) {
  if (isEmpty(str) || ArrayUtils.isEmpty(searchChars)) {
    return -1;
  }
  for (int i = 0; i < str.length(); i++) {
    char ch = str.charAt(i);
    for (int j = 0; j < searchChars.length; j++) {
      if (searchChars[j] == ch) {

nathany

require 'rubygems'
require 'sinatra'
require 'haml'

Domains = %w{gemsmith vogsphere youngman seraph intercessory cyaonline significantwhitespace 14159265358979}
DefaultDomain = 'default'

# what domain does the host contain?
# put this here because helpers are a pain to test!
def view_for_domain(host)

nathany

# Shows the [branch], and an * if there are uncommitted changes.  Example:
# ~/projects/my_project[master*]:

function parse_git_dirty {
  [[ $(git status 2> /dev/null | tail -n1) != "nothing to commit (working directory clean)" ]] && echo "*"
}
function parse_git_branch {
  git branch --no-color 2> /dev/null | sed -e '/^[^*]/d' -e "s/* \(.*\)/[\1$(parse_git_dirty)]/"
}

nathany

- javascript_tag do
  = after_ready do
    = add_ckeditor_plugins(:snippet)

nathany

ActiveRecord::Base.connection.instance_variable_set :@logger, Logger.new(STDOUT)

nathany

# benchmark Pygments from Python
# http://github.com/ryanb/railscasts-episodes/blob/master/episode-207/syntax_benchmarks.rb

from pygments import highlight
from pygments.lexers import RubyLexer
from pygments.formatters import HtmlFormatter

import timeit

# run it once to initialize

nathany

<cfscript>
function decodeToken(stoken, crypt_key) {
  token_bytes = BinaryDecode(URLDecode(stoken), "base64");

  Arrays = CreateObject("java", "java.util.Arrays");
  iv = Arrays.copyOf(token_bytes, 16);
  crypted = Arrays.copyOfRange(token_bytes, 16, ArrayLen(token_bytes));

  decoded_token = DecryptBinary(crypted, crypt_key, "AES/CBC/PKCS5Padding", iv);
  return ToString(decoded_token);