phantom42’s gists

phantom42 / printing out tables pt 2

Created February 22, 2013 04:44

Loops in JavaScript - Extra Tricks

phantom42 / __useful regular expressions.txt

Last active December 14, 2015 02:49

useful regular expressions and regex related stuff

-- collection of useful regular expressions

phantom42 / get actual url entered.cfm

Last active December 14, 2015 08:29

CF code to get the full URL that the user entered. Credit to Ben Nadel http://www.bennadel.com/blog/378-Getting-The-Requested-URL-From-The-Page-Request-Object-Servlet-Without-Using-CGI.htm

	<!--- Get request from ColdFusion page contenxt. --->
	<cfset objRequest = GetPageContext().GetRequest() />

	<!--- Get requested URL from request object. --->
	<cfset strUrl = objRequest.GetRequestUrl().Append(
	"?" & objRequest.GetQueryString()
	).ToString()
	/>

phantom42 / oracle tokenize string.sql

Last active December 14, 2015 20:38

tokenize string to use in oracle WHERE... IN clause. reference: https://blogs.oracle.com/aramamoo/entry/how_to_split_comma_separated_string_and_pass_to_in_clause_of_select_statement

	-- '1,2,3' is the list of ids we would be searching against
	SELECT *
	FROM table
	WHERE id IN
	(
	SELECT REGEXP_SUBSTR('1,2,3','[^,]+', 1, level) from dual
	CONNECT BY REGEXP_SUBSTR('1,2,3', '[^,]+', 1, level) is not null
	)

phantom42 / dump.cfm

Last active August 22, 2016 17:51

CF to dump scopes - especially useful for debugging or working on pages you're unfamiliar with

	<!--- local/variable scope --->
	<cfdump var="#getPageContext().getVariableScope()#" expand="false" label="variable scope"/>
	<!--- all scopes LT cf10 --->
	<cfdump var="#getPageContext().getBuiltInScopes()#"/>
	<!--- all scopes cf10+ --->
	<cfdump var="#getPageContext().getCFScopes()#"/>

phantom42 / IE8-indexOf.js

Created April 19, 2013 17:38

custom function to emulate indexOf method which is not supported by some browsers (IE8)

	if (!Array.prototype.indexOf) {

	Array.prototype.indexOf = function(obj, start) {
	for (var i = (start \|\| 0), j = this.length; i < j; i++) {
	if (this[i] === obj) { return i; }
	}
	return -1;
	}
	}

phantom42 / ie8_console_alert.js

Created April 22, 2013 16:26

console.log override function for browsers without console object - such is IE8 if debugging is not enabled.

	var alertFallback = true;
	if (typeof console === "undefined" \|\| typeof console.log === "undefined") {
	console = {};
	if (alertFallback) {
	console.log = function(msg) {
	alert(msg);
	};
	} else {
	console.log = function() {};
	}

phantom42 / __anchors without href.css

Created April 29, 2013 17:06

selector to style simple anchor tags not being used for links.

	a:not([href]) {
	/* Styles for anchors without href */
	}

phantom42 / gist:6000014

Last active December 19, 2015 18:38

command to export list of file names to a text file

	dir /A:-D /N /S /B > filenames.txt

	forfiles /S /C "cmd /c echo @path0x09@fsize0x09@fdate" > filenames.txt

	for %f in (*.txt) do type "%f" >> combined.txt

phantom42 / tokenize_string.sql

Created September 4, 2013 17:14

	SELECT *
	FROM table a
	WHERE A.column_name IN (
	SELECT REGEXP_SUBSTR('1,2,3','[^,]+', level) FROM dual
	CONNECT BY REGEXP_SUBSTR('1,2,3', '[^,]+', level) is not null
	)

Erik Coleman phantom42