Home : AV Service Providers : Programmers
Sponsors

Programmers

Select an AV Service:

Your Service Location:

Independent AV Programmers

Organizations and individuals within this category of AV programmers focus specifically on the software and other criteria that are so important in the control aspects of an integrated audio visual solution. The control panel(s) is the primary human interface with all the technical functions of an AV system and getting it right is critical as with any sophisticated project. Experience, careful analysis, customer preferences and processes as well as expert knowledge all need to be brought to bear in this critical phase of any AV system. Not only does the control system need to work properly and efficiently but it needs to be intuitive as well.

With today’s technology it is frequently appropriate for AV programmers to design a solution that enables a room to accommodate multiple functions that will be managed by several users, and designing a single control solution that allows the users to manage those various activities seamlessly is no small challenge. The right solution can have unlimited numbers of default configurations for different uses and different users. Multiple screens can be designed within the solution depending on the use of the technology at that moment; buttons can appear and disappear, be arranged in different orders, serve different functions, change size and color and a virtually infinite number of other possibilities. The right solution isn’t just glitzy and colorful; it is foremost easy to use and reliable. Consider the services of an Independent programmer the next time you don’t’ have a simple installation requirement.


Debugging Information
ColdFusion Server Enterprise 10,0,16,293499
Template /AVCat/CTL1642/index.cfm
Time Stamp 04-Aug-15 03:54 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 165.254.210.143
Host Name 165.254.210.143


Execution Time

Total Time Avg Time Count Template
1175 ms 1175 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/AVCat/CTL1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1159 ms 1159 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
1065 ms 1065 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/working/service/service.cfm
1062 ms 1062 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/working/service/AVServices_Search.cfm
54 ms 54 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header.cfm
50 ms 50 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav.cfm
44 ms 44 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
27 ms 27 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/AVCat/CTL1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
23 ms 23 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
10 ms 10 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/working/service/AVServices.cfc | Country(Listing_ID = 5, Market_ID = 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/working/service/AVServices.cfc
9 ms 9 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
9 ms 9 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(1642, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailPIN(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionRRC(1642, RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203122) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/working/ADs.cfc | boxAds(Page_Type_ID = listing, Catalog_ID = 1642, Page_Value = 5) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/working/ADs.cfc
6 ms 6 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/contactus.cfm
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203177) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203198) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203450) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(207407) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203130) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(203202) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(204646) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getPINOptions(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | getBotWords() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeatured() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products.cfm
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | createDynamicListArray(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | startSession() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | handleReturnToURL(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-javascript-caller.cfm
1 ms 1 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/products-content.cfm
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getCatalogType(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getIsLoggedIn(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getMarketID(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | getUserID(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getCatalogID(/AVCat/CTL1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getLanguageID(en) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleLanguage(1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | handleOldDomain(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | setCurrentCatID([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(1642) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateReturnToURL(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(RRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestEnd(/AVCat/CTL1642/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getExclusionKeyList() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bad-css.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-bottom-nav.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-google-analytics-code.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-header-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-region-selector.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/countries.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contactus/states.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/product/states.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
9 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1213 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=0ms, Records=47, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 15:54:05.005
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
MasterQ (Datasource=Ava_Fenster, Time=0ms, Records=735, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:54:05.005
			SELECT	CATALOG_ID,
					Catalog_Option_Int
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'Design_Style'
		
LOCAL.CHECKNOMAD (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:54:05.005
			SELECT	CATALOG_ID
			FROM	MasterQ
			WHERE	CATALOG_ID = ?
					AND Catalog_Option_Int = 2
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

Q (Datasource=Ava_Fenster, Time=3ms, Records=8851, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:54:05.005
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
R (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:54:05.005
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=1, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 15:54:05.005
			{ CALL ctlGetPINOptions(
				?
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

Q (Datasource=Ava_Fenster, Time=2ms, Records=8744, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:54:05.005
			SELECT	Catalog_ID,
					Catalog_Option_Char
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'level'
		
R (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:54:05.005
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

MasterGetCatalogDetailPIN (Datasource=Ava_Fenster, Time=0ms, Records=4, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:54:05.005
			{ CALL GetCatalogDetailALL_PIN }
		
LOCAL.R (Datasource=Ava_Fenster, Time=6ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 15:54:05.005
	     	SELECT	CATALOG_ADDRESS1 ,
					CATALOG_ADDRESS2 ,
					CATALOG_ADDRESS3 ,
					CATALOG_CITY ,
					CATALOG_COMPANY_ID ,
					CATALOG_COUNTRY ,
					CATALOG_DISPLAY_NAME ,
					CATALOG_EMAIL_ADDRESS ,
					CATALOG_ID ,
					CATALOG_PHONE ,
					CATALOG_POSTCODE ,
					CATALOG_STATE_PROVINCE ,
					CATALOG_TYPE_ID ,
					CATALOG_URL ,
					CATALOG_URL_ID ,
					CATEGORY_TREE_ID ,
					COMPANY_DESCRIPTION ,
					CURRENCY_ID	 ,
					MARKET_ID ,
					PROFILE_ID ,
					VISION_IMPORT_ID
			FROM	MasterGetCatalogDetailPIN
			WHERE	CATALOG_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=8, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			{ CALL GETAds (
				? ,
				'groupK' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1642

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203198

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203177

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203130

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203450

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 204646

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 207407

LOCAL.Q (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203122

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 15:54:05.005
			SELECT		AD_ID,
						AD_POSTED_COMPANY_ID,
						AD_POSTED_ID,
						DISPLAY_NAME,
						IMAGE_NAME
			FROM		VARIABLES.GetFeatured
			WHERE 		AD_POSTED_COMPANY_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 203202

proAVServices (Datasource=Ava_Fenster, Time=4ms, Records=16) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\working\service\AVServices_Search.cfm @ 15:54:05.005
	select		Listing_Display,
				Description,
					Listing_id,
					Listing_URL_ID
		from		listing_translation
		where		Language_ID = ?
		and listing_id <> 12
		order by	Listing_Display
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1

Listing_Detail (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\working\service\AVServices_Search.cfm @ 15:54:05.005
			Select	Listing_ID,
					Listing_URL_ID,
					Description,
					Listing_Display,
					Header_Text,
					Listing_Narrative
			from	listing_translation
			where	Listing_URL_ID = ?
					AND Language_ID = ?
					and listing_id <> 12
        
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = av-independent-programmers
Parameter #2(cf_sql_integer) = 1

Country (Datasource=Ava_Fenster, Time=8ms, Records=6) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\working\service\AVServices.cfc @ 15:54:05.005
			select distinct mc.Country
			from Market_Country mc
			join Member_Company member on member.Country = mc.Country 
			join Member_Company_Listing ml on ml.Vision_ID = member.Vision_ID
			where mc.Market_ID = ?
			and ml.Listing_ID = ?
			union
			select distinct mc.Country
			from Market_Country mc
			join COMPANY_LISTING_COUNTRY clc on clc.Country = mc.Country 
			where mc.Market_ID = ?
			and clc.Listing_ID = ?
			order by Country
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 5
Parameter #3(cf_sql_integer) = 1
Parameter #4(cf_sql_integer) = 5

States (Datasource=Ava_Fenster, Time=729ms, Records=51) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\working\service\AVServices_Search.cfm @ 15:54:06.006
    SELECT DISTINCT State
    FROM         ZIP_INFORMATION
    WHERE     (CHARINDEX(' ', ZIP) = 0)
    AND State not in ('AA','AE','AP','AS','FM','GU','MH','MP','PR','PW','VI')
	ORDER BY State
Provinces (Datasource=Ava_Fenster, Time=298ms, Records=13) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\working\service\AVServices_Search.cfm @ 15:54:06.006
    SELECT DISTINCT State
    FROM         ZIP_INFORMATION
    WHERE     (CHARINDEX(' ', ZIP) <> 0)
    ORDER BY State
PageADs (Datasource=Ava_Fenster, Time=4ms, Records=0) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\working\ADs.cfc @ 15:54:06.006
				{ call GETAds (1642,'listing','5','0')}
			


Stored Procedures

GetCatalogDetail (Datasource=Ava_Fenster, Time=0ms) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-go.cfc @ 15:54:05.005

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  1642    
    
resultsets
nameresultset
 LOCAL.Q  1


Scope Variables

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\avcatalogs\avcat\CTL1642\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,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=TE, keep-alive
HTTP_COOKIE=
HTTP_HOST=www.av-iq.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\CTL1642\index.cfm
QUERY_STRING=service=av-independent-programmers
REMOTE_ADDR=165.254.210.143
REMOTE_HOST=165.254.210.143
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/AVCat/CTL1642/index.cfm
SERVER_NAME=www.av-iq.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=42459319
CFTOKEN=4aba56eb2500f136-C6CB8C47-5056-A129-769514F3CF4CD471
USERINFO=0,0
Session Variables:
opts=Struct (37)
sessionid=F2D883EFB3021AB5C39EF167B859DADE.cfusion
urltoken=CFID=42459319&CFTOKEN=4aba56eb2500f136-C6CB8C47-5056-A129-769514F3CF4CD471&jsessionid=F2D883EFB3021AB5C39EF167B859DADE.cfusion
userinfo=Struct (16)
userinfomrc=Struct (3)
URL Parameters:
service=av-independent-programmers
Debug Rendering Time: 70 ms