SELECT *	FROM StatusCodes
    WHERE STATUSCODE <> 'L'

    
      	AND isPublic = '1' 
		    

    ORDER BY Description

SELECT *
				FROM ViewClasses
                
                	WHERE Active = 1
                
				order by Active DESC, Type Desc, Description

SELECT Distinct State
				FROM ViewContractors
				WHERE State IS NOT NULL
				order by State

SELECT Distinct County
				FROM ZipCodes
				WHERE County IS NOT NULL
				order by County

Application Variables:
applicationname=
DS=boc
DS_RES=BOCRes

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=/home/ebecker/git/msboc_search/ConsolidatedResults.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=*/*
http_accept_encoding=gzip, br
http_accept_language=
http_connection=close
http_cookie=
http_host=seevo.it
http_referer=
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
https=off
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=127.0.1.1
local_host=tiger
path_info=
path_translated=/home/ebecker/git/msboc_search/ConsolidatedResults.cfm
query_string=Advanced=1&VarDatasource=BOC
remote_addr=127.0.0.1
remote_host=127.0.0.1
remote_user=
request_method=GET
request_url=http://seevo.it/ConsolidatedResults.cfm?Advanced=1&VarDatasource=BOC
script_name=/ConsolidatedResults.cfm
server_name=seevo.it
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=

Cookie Variables:
cfid=28bd32c5-c1c0-4989-87ad-fd0b3776a02a
cftoken=0

Server Variables:
coldfusion=Struct (9)
java=Struct (8)
lucee=Struct (8)
os=Struct (8)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)

Session Variables:
cfid=28bd32c5-c1c0-4989-87ad-fd0b3776a02a
cftoken=0
lastvisit={ts '2026-10-27 00:28:28'}
login=
sessionid=_28bd32c5-c1c0-4989-87ad-fd0b3776a02a_0
timecreated={ts '2026-10-27 00:28:28'}
urltoken=CFID=28bd32c5-c1c0-4989-87ad-fd0b3776a02a&CFTOKEN=0
vardatasource=boc

URL Variables:
Advanced=1
ContractorType=Commercial
P=
S=
SS=
VarDatasource=BOC