SELECT *
		FROM tstcSQL.dbo.Notifications
		WHERE Method = ? AND 
		      StartDate <= ? AND
					EndDate >= ?
	

	SELECT division.division_id, division.division, 
				 division.accordian_div_name, department.dept_id, dept_status,
	       department.department, department.short_dept_name
	FROM   division INNER JOIN
         department ON division.division_id = department.division_id
	WHERE  division.program_display = ? AND 
	       department.display = ? AND
				 department.dept_status != ?
	ORDER BY division.sort_order, department.sort_order

	SELECT COUNT(division_id) AS DivNums
	FROM   division
	where  display = ? and
	       id <> ?

	SELECT *
	FROM   CLA_Menus
	WHERE  EventDate >= ? AND
	       Status <> ?

Application Variables:
applicationname=TSTCWebSite
settings=Struct (16)

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=C:\_Virtuals\_NewTSTC\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=CFID=14408544; CFTOKEN=57dc3799a71efb2c-23866F01-1143-DB0B-2C1A094B83E58DE9
HTTP_HOST=demo.westtexas.tstc.edu
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/index.cfm
PATH_TRANSLATED=C:\_Virtuals\_NewTSTC\index.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.179.237
REMOTE_HOST=38.107.179.237
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=demo.westtexas.tstc.edu
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFID=14408544
CFTOKEN=57dc3799a71efb2c-23866F01-1143-DB0B-2C1A094B83E58DE9

Session Variables:
cfid=14408544
cftoken=57dc3799a71efb2c-23866F01-1143-DB0B-2C1A094B83E58DE9
sessionid=TSTCWEBSITE_14408544_57dc3799a71efb2c-23866F01-1143-DB0B-2C1A094B83E58DE9
urltoken=CFID=14408544&CFTOKEN=57dc3799a71efb2c-23866F01-1143-DB0B-2C1A094B83E58DE9