orangexception

Find
(.*)\n.*\n

Replace
\1\n

orangexception

	//	FireFox?
	if( $.browser.mozilla ) {
		//	Button Pressed?
		$( "button" ).click( function() {
			//	Delegate Click & Click It
			$( this )
				//	Delegate Click
				.delegate( "a" , "click" , function ( event ) {
					//	Find Anchor

orangexception

	//	Bootstrap IE Collapsable Accordion Issue
	if( $.browser.msie ) {
		//  Accordion Toggle Click Handler
		$( ".accordion-toggle" ).click( function() {
			//	Get Accodion Root
			domAccordion=	$( this ).parents( ".panel-group" );

			//	Hide All Collapsable
			domAccordion.children( ".collpase" ).removeClass( "in" );

orangexception

--  SQL SERVER DATERANGE
--  Generates a list the last 30 dates.

WITH DATERANGE AS (
  SELECT
		CAST( CONVERT( VARCHAR , DATEADD( dd , -30 , GETDATE() ) , 101 ) AS DATETIME ) AS DATE
	UNION ALL
	SELECT
		DATEADD( dd , 1 , DATE )
	FROM	DATERANGE

orangexception

//  MySQL utf8 storage is limited to 3bit characters. When dealing with 4bit characters, then you need to alter the column.

ALTER TABLE `database`.`table` CHANGE COLUMN `Description` `Description` LONGTEXT CHARACTER SET 'utf8mb4' NULL DEFAULT NULL  ;

orangexception

--	SQL Server Suppression Table
--	Suppress Stored Procedure Output

--	Create Suppression Table
CREATE TABLE	#SuppressionTable (
	Value000	VARCHAR(MAX)

)

--	Insert ResultSet into Suppression Table

orangexception

//	Uppercase Words (text-transform: uppercase)
sWords=	REReplace( sWords , "(\w+)" , "\U\1\E" , "all";

orangexception

//	Capitalize Words (text-transform: capitalize;)
sWords=	REReplace( sWords , "(\w+)" , "\u\1" , "all" );

orangexception

--	#	Conditional SQL Statements
--	This technique allows you to write a single query with conditional SQL without using the security hole of `EXECUTE`.

--	Skip The First Conditional
WHERE	1=	1

	--	Conditional SQL:	
	--		This technique allows you to write a single query with conditional SQL without using the security hole of `EXECUTE`.
	--		If @iUserStatusID is 0, then no limit is imposed.
	--		If @iUserStatusID is not 0, then Users.StatusID must equal @iUserStatusID.

orangexception

<cffunction	name=	"minorNamesToString"
			output=	"false"
			hint=	"I convert a query of minor names to a string.">
	<cfargument	name=	"qMinorNames" />

	<cfset	var	sMinorNames=		"" />
	<cfset	var	sPreviousLastName=	"" />

	<!---	Edge Case: 1 Name in Query	--->
	<cfif	qMinorNames.RecordCount EQ 1>