Select productId 
	from products_Main p
	where partNumber like '%Aviation Apps%' 
		and active = 1

				Select * from templateOptions where scriptPath = '/source/features/search/search.cfm'
				and templateOptionTag = 'leftNav' and catalog = 'PilotShop'
			

		 Select * from Categories_Headers 
		where searchTerms like  '%Aviation Apps%' and (catalog like '%A%' or catalog = '*') and categoryHeaderActive = 1
	 

		 Select * from Categories_Headers 
		where searchTerms like  '%*%' and (catalog like '%A%' or catalog = '*') and categoryHeaderActive = 1
	 

Application Variables:
applicationname=BugTestApplication

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\source\features\search\search.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.sportys.com
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/4.0 (compatible; Win32; WinHttp.WinHttpRequest.5)
PATH_INFO=/source/features/search/search.cfm
PATH_TRANSLATED=E:\inetpub\wwwroot\source\features\search\search.cfm
QUERY_STRING=page=1&keywords=Aviation%20Apps&catalog=PilotShop&x=0&y=0&display_type=List
REMOTE_ADDR=172.23.34.101
REMOTE_HOST=172.23.34.101
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/source/features/search/search.cfm
SERVER_NAME=www.sportys.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)

URL Parameters:
CATALOG=PilotShop
DISPLAY_TYPE=List
KEYWORDS=Aviation Apps
PAGE=1
X=0
Y=0