iampeterbanjo

SELECT NEW_LINE_INDEX
  FROM (
  SELECT INSTR(value, "\n")
		AS NEW_LINE_INDEX
    FROM table
    WHERE value != ""
    ORDER BY value
  ) findNewLines
	WHERE NEW_LINE_INDEX > 0
;

iampeterbanjo

//there are exceptions to the rule
{
   "property1"  :  "value1",
   "property2"  :  "value2",
   "property3"  :  ["value3.1","value3.2"]
}

iampeterbanjo

//listen for hash tag changes so we can remove the popup
$(window).bind('hashchange',
    function(event){
        //did we add or substract the hash?
        var currentHash = window.location.hash;
        currentHash = currentHash.slice(1);
        if(window.console && debug){
            console.log(['listings.js: hashchange event detected. currentHash is ', currentHash ].join(''));
        }