PreserveSingleQuotes - Quick Test Cases

<cfset qry=query(a:["susi's"])>

<cfset SampleText="Susi's">

<cfset i = 0/>


<cftry>
	<cfset TestCase[++i].Label = "no attr,no func" />
	<cfquery dbtype="query" name="TestCase[i].Query">
		select * from qry where a='#LCase(SampleText)#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "+attr,no func" />
	<cfquery dbtype="query" name="TestCase[i].Query" psq=true>
		select * from qry where a='#LCase(SampleText)#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "-attr,no func" />
	<cfquery dbtype="query" name="TestCase[i].Query" psq=false>
		select * from qry where a='#LCase(SampleText)#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "no attr,func 1" />
	<cfquery dbtype="query" name="TestCase[i].Query">
		select * from qry where a='#PreserveSingleQuotes(LCase(SampleText))#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "no attr,func 2" />
	<cfquery dbtype="query" name="TestCase[i].Query">
		select * from qry where a='#LCase(PreserveSingleQuotes(SampleText))#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "+attr,func 1" />
	<cfquery dbtype="query" name="TestCase[i].Query" psq=true>
		select * from qry where a='#PreserveSingleQuotes(LCase(SampleText))#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "+attr,func 2" />
	<cfquery dbtype="query" name="TestCase[i].Query" psq=true>
		select * from qry where a='#LCase(PreserveSingleQuotes(SampleText))#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "-attr,func 1" />
	<cfquery dbtype="query" name="TestCase[i].Query" psq=false>
		select * from qry where a='#PreserveSingleQuotes(LCase(SampleText))#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cftry>
	<cfset TestCase[++i].Label = "-attr,func 2" />
	<cfquery dbtype="query" name="TestCase[i].Query" psq=false>
		select * from qry where a='#LCase(PreserveSingleQuotes(SampleText))#'
	</cfquery>

<cfcatch><cfset TestCase[i].Error=cfcatch.message/></cfcatch>
</cftry>


<cfdump eval=TestCase />