About the Presenatation Source
Learn about the Presentation Sources Valued Partnerships
Presentation Source Solutions
Contact the Presentation Source
Call Us Toll Free

Pro AV Catalog
Sign Up for a Free My-iQ Account
It takes less than a minute, and here's what you'll get:
Save Items to Project Lists
By saving items to project lists, you can easily create, manage and share project lists.
Access MSRP Pricing
Many of our manufacturers provide MSRP pricing. As a registered user you’ll have access to this important piece of information.
Stay Updated
Get updates from manufacturers and stay up to date with the latest news from the industry leading sources.
Easily Compare
Using the comparison tool, you can add a limitless number of products to compare side by side.
Sign up below:
Tell us about yourself

Email is not valid or already exists

Your password needs to contain the following:

  At least six characters
  At least one letter
  At least one number
CTS CTS-D CTS-I
By clicking Create Your Account you are agreeing to the Terms & Conditions
About the Presentation Source
View our Product Catalog
Sign up for our Newsletter
Call us for a quote
Learn about our partners
Learn about our latest products
Schedule A Service Appointment
Directions to the Presenation Source
Let us create the perfect Solution for your business
Learn about the latest industry news
Request a Quote
Email the Presentation Source
A Proud Member of the Rochester Top 100
A proud member of the Rochester Business Alliance
A proud member of the ncsa
Infocomm
A proud member of the better business bureau


Debugging Information
ColdFusion Server Enterprise 10,0,19,298511
Template /avcat/ctl3203/index.cfm
Time Stamp 23-Jun-17 02:55 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.198.147.79
Host Name 54.198.147.79


Execution Time

Total Time Avg Time Count Template
145 ms 145 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequest(/avcat/ctl3203/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
129 ms 129 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-index.cfm
34 ms 34 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestStart(/avcat/ctl3203/index.cfm) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
30 ms 30 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfm
30 ms 30 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfm
26 ms 26 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-top-nav-treatment.cfm
24 ms 24 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration-form.cfm
19 ms 19 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfm
15 ms 15 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | qIDFind(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
13 ms 13 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfm
11 ms 11 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSession(3203, 1) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
9 ms 9 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogLevel(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getTreatmentOptions([complex value], 3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | getCatalogDetailMRC(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
8 ms 8 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getCountryOptions(Select Country) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | getMRCOptions(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
7 ms 7 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getCountryOptions(Select Country) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
6 ms 6 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | handleSessionMRC(3203, MRC) ] 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(305815) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
5 ms 5 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedDetail(210018) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
4 ms 4 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc | checkShowCaseStudies(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | checkUserAgent() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getEmployerTypes() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
3 ms 3 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getPositions() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.cfc | getCatalog(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-go.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/nomad/base-global-options.cfc | handleReturnToURL(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-global-options.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getBasicUserInfo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
2 ms 2 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc | getFeaturedForDealer() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/mans.cfc
2 ms 2 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-css-caller.cfm
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-start.cfc | handleOldDomain(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateUserCookie(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onSessionStart() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
1 ms 1 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getStateOptions(Work State / Province, ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
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 | makeMetaDescription(Sign Up for a Free My-iQ Account. It takes less than a minute, and here's what you'll get. Save Items to Project Lists. Access MSRP Pricing. Easily Compare Products. The Presentation Source Inc..) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc | makeMetaTitle(Sign Up for a Free My-iQ Account | The Presentation Source Inc.) ] from E:/inetpub/wwwroot/avcatalogs/avcat/UDF/UDFs.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-request-start.cfc | checkIsNomad(3203) ] 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 | getCatalogID(/avcat/ctl3203/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 | 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 | createDynamicListArray(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | deleteListArray(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | getCatalogType(3203) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | startSession() ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc | updateReturnToURL(MRC) ] from E:/inetpub/wwwroot/avcatalogs/avcat/application-session.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/application.cfc | onRequestEnd(/avcat/ctl3203/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/base.cfc | createFacebookMetaData([complex value]) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc | getStateOptions(Select State, ) ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/contact.cfc
0 ms 0 ms 1 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | getMaxlengthInfo() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc
0 ms 0 ms 2 CFC[ E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.cfc | init() ] from E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.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/ctl3203/index-bottom.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/ctl3203/index-top.cfm
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-footer-nb-page.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/base-footer-pardot-doubleclick.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-javascript-caller.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/contact/zip-modal.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/exitmessage/exitmessage.cfm
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/myiq-registration/registration.css
0 ms 0 ms 1 E:/inetpub/wwwroot/avcatalogs/avcat/nomad/topnav/search.cfm
10 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
190 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

LOCAL.Q (Datasource=Catalog_Sessions, Time=1ms, Records=48, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application.cfc @ 14:55:31.031
			SELECT		*
			FROM		SESSION_BROWSER_EXCLUDE
		
LOCAL.Q (Datasource=Ava_Fenster, Time=8ms, Records=8955, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:55:31.031
			SELECT	Catalog.Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	Catalog
		
LOCAL.R (Datasource=Ava_Fenster, Time=5ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:55:31.031
			SELECT	Catalog_ID,
					Catalog_Type_ID,
					Market_ID
			FROM	[LOCAL].Q
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3203

LOCAL.GetALLMRCSAndOptions (Datasource=Ava_Fenster, Time=1ms, Records=152, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:55:31.031
			{ CALL GetALLMRCSAndOptions() }
		
LOCAL.R (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\application-request-start.cfc @ 14:55:31.031
			SELECT	*
			FROM	[LOCAL].GetALLMRCSAndOptions
			WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3203

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=8953, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:55:31.031
			SELECT	Catalog_ID,
					Catalog_Option_Char
			FROM	CATALOG_OPTIONS
			WHERE	Option_ID = 'level'
		
R (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:55:31.031
				SELECT	Catalog_Option_Char
				FROM	VARIABLES.Q
				WHERE	Catalog_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3203

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:55:31.031
	
			DECLARE @Catalog_ID int = ?
			DECLARE @ShowCaseStudyLink bit = (	
		       	SELECT 
					ShowCaseStudyLink = 
						CASE
                           	WHEN CO.Catalog_Option_Bit IS NULL OR CO.Catalog_Option_Bit = 0 OR CO.Catalog_Option_Bit = '' THEN 1
                           	ELSE 0
	                    END
				FROM 
					dbo.[CATALOG] AS C
					LEFT OUTER JOIN CATALOG_OPTIONS AS CO
	                    ON CO.Catalog_ID = C.Catalog_ID
                        	AND CO.Option_ID = 'DisableCaseStudies'
				WHERE 
					EXISTS (
	                    SELECT 
	                    	*
    	                FROM 
    	                	dbo.[Profile] AS P
						WHERE 
                           P.Publish = 1 
                           AND  P.Active = 1
                           AND P.Company_ID = C.Catalog_Company_ID
					)
					AND EXISTS (
	                    SELECT 
	                    	* 
	                    FROM 
	                    	COMPANY_CLASSIFICATION AS CC
	                    WHERE 
                           CC.Company_Type_ID = 'Reseller'
                           AND CC.Company_ID = C.Catalog_Company_ID
					)
					AND C.Catalog_ID = @Catalog_ID 
			)
			SELECT 
				ShowCaseStudyLink = 
					CASE 
                    	WHEN @ShowCaseStudyLink IS NULL OR @ShowCaseStudyLink = '' OR @ShowCaseStudyLink = 0 THEN 0 
	                    ELSE 1 
					END
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3203

LOCAL.MasterGetCatalogDetailMRC (Datasource=Ava_Fenster, Time=0ms, Records=151, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:55:31.031
			{ CALL GetCatalogDetailALL_MRC }
		
LOCAL.R (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base-global-options.cfc @ 14:55:31.031
	     	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	[LOCAL].MasterGetCatalogDetailMRC
			WHERE	CATALOG_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3203

LOCAL.Q (Datasource=Ava_Fenster, Time=0ms, Records=2, Cached Query) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:55:31.031
			{ CALL GETAds (
				? ,
				'groupA' ,
				'0' ,
				'0'
			) }
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3203

LOCAL.Q (Datasource=Ava_Fenster, Time=4ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:55:31.031
			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) = 210018

LOCAL.Q (Datasource=Ava_Fenster, Time=3ms, Records=1) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\topnav\mans.cfc @ 14:55:31.031
			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) = 305815

LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=26) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\myiq-registration\registration.cfc @ 14:55:31.031
			SELECT		Employer_Type_ID,
						Employer_Type_Name
			FROM		MyiQ_Employer_Types
			WHERE		
						Employer_Type_ID > 10 AND Employer_Type_ID < 100
			ORDER BY	Employer_Type_Name
		
LOCAL.Q (Datasource=Ava_Fenster, Time=2ms, Records=19) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\myiq-registration\registration.cfc @ 14:55:31.031
			SELECT		Position_ID,
						Position_Name
			FROM		MyiQ_Positions
			WHERE		
						Position_ID > 10 AND Position_ID < 100
			ORDER BY	Position_Name
		
LOCAL.GetCountries (Datasource=Ava_Fenster, Time=4ms, Records=244) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base.cfc @ 14:55:31.031
			SELECT 		Country_Code_ID ,
						Country_Abbr , 
						Country
			FROM 		Country_Code
			ORDER BY 	Country
		
LOCAL.GetCountries (Datasource=Ava_Fenster, Time=6ms, Records=244) in E:\inetpub\wwwroot\avcatalogs\avcat\nomad\base.cfc @ 14:55:31.031
			SELECT 		Country_Code_ID ,
						Country_Abbr , 
						Country
			FROM 		Country_Code
			ORDER BY 	Country
		


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  3203    
    
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\ctl3203\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=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.av-iq.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR=audiovisual.cbcitelecom.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\avcatalogs\avcat\ctl3203\index.cfm
QUERY_STRING=myiq-registration=t
REMOTE_ADDR=54.198.147.79
REMOTE_HOST=54.198.147.79
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/avcat/ctl3203/index.cfm
SERVER_NAME=www.av-iq.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Cookie Variables:
CFID=297524736
CFTOKEN=7b679660502474f9-5F1391F3-5056-A129-767F306B8048FEDF
USERINFOMRC=0,0
Session Variables:
opts=Struct (42)
sessionid=CA04B5E908AA6630BA96B5FEE3D79FE8.cfusion
urltoken=CFID=297524736&CFTOKEN=7b679660502474f9-5F1391F3-5056-A129-767F306B8048FEDF&jsessionid=CA04B5E908AA6630BA96B5FEE3D79FE8.cfusion
userinfo=Struct (6)
userinfomrc=Struct (13)
userinforrcpvd=Struct (0)
URL Parameters:
myiq-registration=t
Debug Rendering Time: 79 ms