Staging web site. (this banner will not appear on your "live" website)

Courses

This message can be edited by you. Please look through these categories to find the topics that interest you. Clicking on a topic will link you to a list of course titles in that subject area. From there you can go to individual course descriptions and classes.
You may also search for a course by its title, number, or instructor.

This message can be edited by you. The programs chosen to be included in ABC's Adult Education program are selected because of unique interest to the community, and offer an enticing perspective on an interesting subject. All of our instructors are interviewed and selected for their confidence in their subject and their willingness to share their expertise.

We welcome input from the community of students. If you are interested in teaching a course, please go to the teaching page for more information.

Debugging Information

ColdFusion Server Enterprise	2021,0,21,330446
Template	/index.cfm
Time Stamp	02-Aug-25 10:00 AM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	172.31.102.40
Host Name	172.31.102.40

Execution Time

Total Time	Avg Time	Count	Template
385 ms	385 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc
370 ms	370 ms	1	E:/Lumens/Versions/v81QA/globalVariables.cfm
354 ms	354 ms	1	E:/Lumens/Versions/v81QA/Administration/SQL/MenuQry.cfm
141 ms	141 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequest(/index.cfm) ] from E:/Lumens/Application.cfc
141 ms	141 ms	1	E:/Lumens/Versions/v81QA/index.cfm
125 ms	125 ms	1	E:/Lumens/Versions/v81QA/Fusebox1.cfm
79 ms	79 ms	1	E:/Lumens/Versions/v81QA/templates/courses.cfm
31 ms	31 ms	1	E:/Lumens/Versions/v81QA/SQL/CatSubcatQry.cfm
16 ms	16 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/textEdit.cfc \| returnText(courses, 2, 1, GenooSandbox, ) ] from E:/Lumens/versions/v81QA/cfc/textEdit.cfc
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/SQL/ContentsQry.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/header.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/view-cart.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/header_section.cfm
15 ms	15 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc
15 ms	15 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| processRequest(ip_address = 216.73.216.8) ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
15 ms	15 ms	1	E:/Lumens/Versions/v81QA/SQL/CatalogIsExternal.cfm
0 ms	0 ms	3	CFC[ E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc \| INIT(GenooSandbox) ] from E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc \| INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getGraphicsDetails(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getSiteResourcePathDetailsByID(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc \| decodeEntities(/index.cfm?catalogid=2&fuseaction=1010) ] from E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc \| decodeEntities(catalogid=2&fuseaction=1010) ] from E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc \| inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc \| inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| getRequestIPAddress() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc \| shouldReInitialize() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc
0 ms	0 ms	3	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| init(GenooSandbox) ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	6	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| isCartExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc \| isCartMerchandiseExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc \| init(GenooSandbox) ] from E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| INIT() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| getFooterNavItems() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc \| getUserNavItems() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81QA/cfc/textEdit.cfc \| returnText(courses, 1, 1, GenooSandbox, ) ] from E:/Lumens/versions/v81QA/cfc/textEdit.cfc
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Administration/SQL/CustomizationsQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/AppVariables.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/Circuits.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/SQL/GetCatalog.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/SQL/GetDefaultCatalog.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/SQL/GetExternalCourseProvider.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/SQL/RegionDetailQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/checkPermission.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/intercepts.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/nLoadVars.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/plugins/GlobalFunctions.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/templates/checkPermissionForUserRole.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/templates/loggedUserDetail.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/udf/getText.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/udf/index.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/udf/logger.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/back-top-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/branding-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/cart.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/client-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/facebook-pixel.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-analytics.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-tag-manager.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/menu_action.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-account.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-social-media.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/search.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/footer_section.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/custom_style.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/nav-main.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/nav-tabs.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81QA/view/css/style.cfm
0 ms	0 ms	1	E:/Lumens/shared/CustomTags/UpdateMetaTagContent.cfm
0 ms	0 ms	1	E:/Lumens/shared/CustomTags/UpdatePageTitle.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
526 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 121

	    Element ROOMNAME is undefined in REQUESTROOMRSVNQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 128

	    Element CLASSTIMEDISPLAY is undefined in VARIABLES.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 135

	    Element LOCATIONNAME is undefined in REQUESTROOMRSVNQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 142

	    Element CLASSNAME is undefined in REQUESTROOMRSVNQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 163

	    Element CLASSSETUP.EVENTNAME is undefined in SESSION.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 170

	    Variable CLASSSCHEDULEDISP is undefined.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 177

	    Element ROOMNAME is undefined in GETROOMDATAFOREMAILQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 184

	    Element ROOMCONTACTNAME is undefined in GETROOMDATAFOREMAILQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 191

	    Element LOCATIONNAME is undefined in GETROOMDATAFOREMAILQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 201

	    Element BIRTHDATE is undefined in GETLEARNERAGEQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 208

	    Element GRADELEVEL is undefined in GETLEARNERAGEQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 222

	    Element COMPANYNAME is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 229

	    Element COMPANYUSER is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 236

	    Element BASECLASSFEE is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 244

	    Element COURSENUMBER is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 252

	    Element CLASSDESCRIPTION is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 259

	    Element CLASSSCHEDULEDISPLAY is undefined in VARIABLES.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 266

	    Element INSTRNAME is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 121

	    Element ROOMNAME is undefined in REQUESTROOMRSVNQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 128

	    Element CLASSTIMEDISPLAY is undefined in VARIABLES.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 135

	    Element LOCATIONNAME is undefined in REQUESTROOMRSVNQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 142

	    Element CLASSNAME is undefined in REQUESTROOMRSVNQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 163

	    Element CLASSSETUP.EVENTNAME is undefined in SESSION.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 170

	    Variable CLASSSCHEDULEDISP is undefined.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 177

	    Element ROOMNAME is undefined in GETROOMDATAFOREMAILQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 184

	    Element ROOMCONTACTNAME is undefined in GETROOMDATAFOREMAILQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 191

	    Element LOCATIONNAME is undefined in GETROOMDATAFOREMAILQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 201

	    Element BIRTHDATE is undefined in GETLEARNERAGEQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 208

	    Element GRADELEVEL is undefined in GETLEARNERAGEQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 222

	    Element COMPANYNAME is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 229

	    Element COMPANYUSER is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 236

	    Element BASECLASSFEE is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 244

	    Element COURSENUMBER is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 252

	    Element CLASSDESCRIPTION is undefined in MASTERROSTERQRY.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 259

	    Element CLASSSCHEDULEDISPLAY is undefined in VARIABLES.

10:00:37.037 - Expression Exception - in E:/Lumens/Versions/v81QA/udf/getText.cfm : line 266

	    Element INSTRNAME is undefined in MASTERROSTERQRY.

SQL Queries

checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=10) in E:\Lumens\Versions\v81QA\checkPermission.cfm @ 10:00:36.036

SELECT DISTINCT ACA.int_actor_type_id
			FROM tbl_access_control_rules ACR
			INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id
			WHERE
				
					str_fuse_action LIKE ? 
				AND ISNULL(ACA.int_actor_type_id,'')<>''
				AND ACA.bit_allow = 1

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = 1010

MenuQry (Datasource=GenooSandbox, Time=354ms, Records=9) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:00:37.037

SET NOCOUNT ON

			SELECT OrgID
				, RegionID
				, MenuItemID
				, MenuItemType
				, MainLevel
				, SubLevel
				
				,MainLevelSortOrder
				, SubLevelSortOrder
				, 
					SiteURL
				
				, AccessLevel
				, IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1
				
				, IsNull(DisplayValue_1, '') AS DisplayValue_1
				, IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2
				, IsNull(DisplayValue_2, '') AS DisplayValue_2
				, Condition
				, LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName
				, m.Label AS UniqueLable
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member')
										/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate')
										/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"')
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN (str_user_nav_label)
							ELSE str_user_nav_label
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS Label
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(m.Label, 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(m.Label, 'Member', 'Member')
									/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate')
									/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE m.Label
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN dbo.fun_strip_html((str_user_nav_label))
							ELSE dbo.fun_strip_html(str_user_nav_label)
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS LabelNoHTML 
				
				, ISNULL(int_parent_id,0) as int_parent_id
				, int_sort_order
				, m.UniqueLabel
				, m.bit_default_behavior
			FROM MenuItems m
			LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id
			WHERE STATUS = 'A'
				AND SubCategoryID IS NULL
				AND (
					
						int_actor_type_id = ?
						OR
						(
							int_actor_type_id IS NULL
							AND AccessLevel = ?
						)
					
				)
				
				AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/
				
			ORDER BY int_sort_order

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 90

qGetDashboardName (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:00:37.037

SET ANSI_NULLS ON

		SELECT IsNull((
					CASE
						WHEN str_dashboard_name = ''
							THEN NULL
						ELSE str_dashboard_name
						END
					), CASE
					WHEN ActorTypeID = 55
						THEN 'Dashboard'
					ELSE 'my dashboard'
					END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */
		FROM ActorTypes
		WHERE ActorTypeID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

qLearnerfields (Datasource=GenooSandbox, Time=0ms, Records=107) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:00:37.037

SELECT pfo.int_order
				, pf.str_field_display_name
				, pf.str_field_name
				, pfo.int_profile_field_tab_id
				, pf.str_actor_types
				, pf.chr_field_type
			FROM tbl_profile_field_order pfo
			INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id
			WHERE pf.int_region_id = ?
				AND bit_enabled = ?
				AND
				(
					(
						pf.chr_field_type not in ('C','O')
					)
					
						OR
						(
							pf.chr_field_type in ('C','O') AND
							(
								pf.str_actor_types LIKE ? 
							)
						)
					
				)
			ORDER BY pfo.int_profile_field_tab_id
				, pfo.int_order ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_varchar) = %90%

qsocialNetFieldDetails (Datasource=GenooSandbox, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:00:37.037

select * from tbl_social_media_details WHERE int_region_id = ?
			order by int_order asc

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qGraphics (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:00:37.037

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qUserNavItems (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:00:37.037

SELECT menitms.SiteURL AS nav_site_url
			, menitms.label AS nav_label
			, menitms.rowNum
			, COUNT(menitms.rowNum) OVER () AS Total_Rows
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel 
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_nav=1
				AND STATUS = ?
				
	) menitms

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_char) = A

qFooterNavItems (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:00:37.037

SELECT menitms.SiteURL
			, menitms.label
			, menitms.AccessLevel
			, menitms.rowNum
			, ((rowNum - 1) / 4) + 1 AS block
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, AccessLevel
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel
			
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_footer=1
				AND STATUS = ?
				
	) menitms

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 90

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_char) = A

CommonPasswords (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 10:00:37.037

DECLARE @currentTime DATETIME2 = ?
				UPDATE tbl_cart_class_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;
				UPDATE tbl_cart_merchandise_detail
				SET EnteredDate = @currentTime
				WHERE SessionID = ?;

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-02 10:00:37.17

			    
			        Parameter #2(cf_sql_varchar) = 7D3521CBAA9AD1303CA9F155788F7DD0.cfusion

			    
			        Parameter #3(cf_sql_varchar) = 7D3521CBAA9AD1303CA9F155788F7DD0.cfusion

variables.custom_scripts (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 10:00:37.037

SELECT str_header_script
				, str_footer_script
			FROM tbl_style_settings WITH (NOLOCK)
			-- WHERE int_region_id = Commented as long as multiple regions are not there

qTempMenu (Datasource=, Time=0ms, Records=5) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 10:00:37.037

select * from qTempMenu where MenuItemID NOT IN  (529,600,2,456)

qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 10:00:37.037

select * from qSocialMedia order by int_order desc

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 3

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 6

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 13

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 16

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 19

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 22

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 27

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 32

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 35

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 42

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qCourseMenu where int_parent_id = ? 
					and MenuItemType = ?
					and Label <> ?
					and int_parent_id<>0

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 49

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qMenu where int_parent_id = 513

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qMenu where int_parent_id = 520

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qMenu where int_parent_id = 5

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qMenu where int_parent_id = 6

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:00:37.037

select * from qMenu where int_parent_id = 7

CustomizationsQry (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\Administration\SQL\CustomizationsQry.cfm @ 10:00:37.037

SELECT OrgID, RegionID, CustomizationID, rtrim(ltrim(FuseAction)) as fuseAction, Status, 
	CASE Status When 'A' Then 'Active' When 'I' Then 'Inactive' END AS StatusDesc,
	CreateDate, CustomizationName, CustomizationDesc
	FROM Customizations c
	WHERE Status = 'A'
	AND RegionID = 1
	Order By Status, Fuseaction

qCatalogIsExternal (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\CatalogIsExternal.cfm @ 10:00:37.037

SELECT	Catalogs.CatalogID,
			Catalogs.Status,
			Catalogs.SystemCatalog,
			CASE WHEN ExternalCourseProvider.DefaultCatalogID IS NULL THEN 0
				 ELSE 1
			END AS IsExternalCourseProviderDefaultCatalog
	FROM	Catalogs
			LEFT JOIN ExternalCourseProvider
				ON ExternalCourseProvider.DefaultCatalogID = Catalogs.CatalogID
	
		WHERE	Catalogs.CatalogID IN (?)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 2

qExternalDefaultCatalog (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\CatalogIsExternal.cfm @ 10:00:37.037

SELECT * FROM qCatalogIsExternal WHERE IsExternalCourseProviderDefaultCatalog = 1 AND SystemCatalog = 1

qNotExternalDefaultCatalogs (Datasource=, Time=15ms, Records=0) in E:\Lumens\Versions\v81QA\SQL\CatalogIsExternal.cfm @ 10:00:37.037

SELECT * FROM qCatalogIsExternal WHERE IsExternalCourseProviderDefaultCatalog = 0

RegionDetailQry (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\RegionDetailQry.cfm @ 10:00:37.037

SET NOCOUNT ON

SELECT rg.ApplName
    , rg.NAME
    , rg.EMail
    , rg.EMailAux1
    , rg.EMailAux2
    , rg.EMailAux3
    , rg.EMailAux4
    , rg.EMailAux5
    , rg.EMailAux6
    , rg.theUrl
    , rg.BadWeatherText
    , rg.Phone1
    , rg.Phone1Ext
    , rg.Address1
    , rg.Address2
    , rtrim(rg.City) + ', ' + rg.STATE + '  ' + rg.Zip AS CSZ
    , rg.City
    , rg.STATE
    , rg.Zip
    , rg.ZipPlus4
    , rg.Footer
    , rg.SiteTitle
    , rtrim(rg.City) + ', ' + rg.STATE + ', ' + rg.Zip AS OrganizationCityStateZip
FROM Regions rg
WHERE rg.RegionID = ?
    AND rg.Status = 'A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

OrganizationDetailQry (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\RegionDetailQry.cfm @ 10:00:37.037

SET NOCOUNT ON

    SELECT rg.ApplName
        , rg.NAME AS OrganizationName
        , rg.EMail
        , rg.EMailAux1
        , rg.EMailAux2
        , rg.EMailAux3
        , rg.EMailAux4 AS Mailbox4
        , rg.EMailAux4 AS Mailbox5
        , rg.theUrl
        , rg.BadWeatherText
        , rg.Phone1 AS OrganizationPhone
        , rg.Phone1Ext
        , rg.Address1 AS OrganizationAddress
        , rg.Address2 AS OrganizationAddress2
        , rtrim(rg.City) + ', ' + rg.STATE + ', ' + rg.Zip AS OrganizationCityStateZip
        , rg.City
        , rg.State
        , rg.Zip
        , rg.ZipPlus4
        , rg.Footer
        , rg.SiteTitle
        -- Issue TT59300 OrganizationCity,OrganizationState,OrganizationZip
        , rg.City AS OrganizationCity
        , rg.State AS OrganizationState
        , rg.Zip AS OrganizationZip
    FROM Regions rg
    WHERE rg.RegionID = ?
        AND rg.Status = 'A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

GetDefaultCatalog (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\GetDefaultCatalog.cfm @ 10:00:37.037

SELECT TOP 1 CatalogID FROM Catalogs 
	WHERE SystemCatalog = 1
	AND Name = 'All Catalogs'
	ORDER BY SortOrder

CatSubcatQry (Datasource=GenooSandbox, Time=31ms, Records=9) in E:\Lumens\Versions\v81QA\SQL\CatSubcatQry.cfm @ 10:00:37.037

SET NOCOUNT ON

		DECLARE @str_alt AS VARCHAR(max)
			, @intNumber_wAltSubCat AS INT
			, @AllcatalogId AS INT
			, @CatalogID AS INT
			, @AltCatalogID AS VARCHAR(20)
			, @currentTimeZoneOffsetDate DATETIME2 = ?
			, @MemberShipTypeID INT;

		SET @AllcatalogId = ( SELECT catalogid FROM catalogs WHERE NAME = 'All Catalogs' );
		SET @CatalogID = ?;
		SET @AltCatalogID = ?;
		SET @MemberShipTypeID = ?;
		/**/

		SET @intNumber_wAltSubCat = (
			SELECT count(ClassListingID) AS Number_wAltSubCat
			FROM tbl_class_listing tcl WITH (NOLOCK)
			
			WHERE ( tcl.str_alt_subcategory_ids IS NULL OR tcl.str_alt_subcategory_ids > '' )
				AND
				
					@currentTimeZoneOffsetDate BETWEEN tcl.AppearanceStartDate
						AND tcl.AppearanceEndDate
				
					AND tcl.bit_display_to_public = 1
				
		)


		IF object_id('tempdb..#temp') IS NOT NULL
		BEGIN
			DROP TABLE #temp
		END

		IF object_id('tempdb..#temp1') IS NOT NULL
		BEGIN
			DROP TABLE #temp1
		END

		IF object_id('tempdb..#temp2') IS NOT NULL
		BEGIN
			DROP TABLE #temp2
		END

		IF object_id('tempdb..#temp3') IS NOT NULL
		BEGIN
			DROP TABLE #temp3
		END

		SELECT Subcategories.subcategoryid
		INTO #temp1
		FROM tbl_class_listing Classes WITH (NOLOCK)
		LEFT JOIN Catalogs WITH (NOLOCK) ON Classes.CatalogID = Catalogs.CatalogID
		INNER JOIN Courses WITH (NOLOCK) ON Classes.CourseID = Courses.CourseID
		
		INNER JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = classes.classid
			AND (
				Classes.chr_Status = 'A'
				OR Classes.chr_Status = 'C'
			)
			
				AND (tcd.bit_display_to_public = 1)
				AND Classes.classid IN (
					SELECT classid
					FROM tbl_class_listing cl1 WITH (NOLOCK)
					LEFT JOIN MembershipTypes mt1 
						ON mt1.MembershipTypeID IN (
							SELECT value 
							FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
						)
					WHERE (
						mt1.MemberShipTypeID = @MemberShipTypeID 
						OR mt1.bit_display_classes_members_only = 0
					)

					UNION

					SELECT classid
					FROM tbl_class_listing cl1 WITH (NOLOCK)
					WHERE (cl1.str_limit_self_reg_mbrship_type_ids = '')
						OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
						OR (cl1.str_limit_self_reg_mbrship_type_ids = '0')
					)
			
			AND
			
				@currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate
					AND Classes.AppearanceEndDate
			
			AND Classes.ClassID NOT IN (
				SELECT cx.ClassID
				FROM ProgramSectionClasses cx
				GROUP BY cx.ClassID
				)
			
					AND (
						Classes.CatalogID IN (
							@CatalogID
							, @AllcatalogId
							)
						OR ',' + Classes.str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
						)
				
		INNER JOIN Subcategories WITH (NOLOCK) ON Subcategories.SubcategoryID = Courses.SubcategoryID

		SELECT sbc.subcategoryid
			, cl1.AppearanceEndDate
			, Cl1.classid
			, cl1.str_limit_self_reg_mbrship_type_ids
			, AppearanceStartDate
			, Cl1.CatalogID
			, cl1.str_alt_catalog_ids
		INTO #temp2
		FROM tbl_class_listing cl1 WITH (NOLOCK)
		LEFT JOIN Catalogs WITH (NOLOCK) ON cl1.CatalogID = Catalogs.CatalogID
		INNER JOIN Courses WITH (NOLOCK) ON cl1.CourseID = Courses.CourseID
		INNER JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = cl1.classid
		
		INNER JOIN tbl_class_course_series_group tcs WITH (NOLOCK) ON tcs.int_class_id = tcd.int_class_id
			AND (
				cl1.chr_Status = 'A'
				OR cl1.chr_Status = 'C'
				)
			AND (tcd.bit_display_to_public = 1)
			AND cl1.ClassID NOT IN (
				SELECT cx.ClassID
				FROM ProgramSectionClasses cx WITH (NOLOCK)
				GROUP BY cx.ClassID
				)
			
			
		INNER JOIN Subcategories sbc WITH (NOLOCK) ON sbc.SubcategoryID = Courses.SubcategoryID

		/*Multiple subcategory display PAV 26 Aug 2009 This section gets a list of subcategory ids which have been assigned to classes as alternate subcategory ids*/
		/* sample code obtained from http://rafudb.blogspot.com/2009/04/sysconnectbypath-in-sql-server_24.html */
		/* This flattens the comma delimited values from several rows into one field and places them into a temp table */
		IF @intNumber_wAltSubCat > 0
		BEGIN
			
			SELECT DISTINCT t.[value]
			INTO #temp
			FROM tbl_class_listing col1 WITH (NOLOCK)
			
			CROSS APPLY STRING_SPLIT(str_alt_subcategory_ids,',') t
			WHERE str_alt_subcategory_ids IS NOT NULL
				
					AND @currentTimeZoneOffsetDate BETWEEN AppearanceStartDate
						AND AppearanceEndDate
				
				AND 0 < (
					CASE
						WHEN str_class_type = 'CS'
							THEN (
									SELECT COUNT(ClassID)
									FROM Classes Cl
									INNER JOIN tbl_class_course_series_group tcc ON tcc.int_class_id = CL.ClassID
									WHERE tcc.int_Series_group_id = col1.int_course_series_group_id
										AND Cl.STATUS = 'A'
									)
						ELSE 1
						END
					)
				
						AND (
							CatalogID IN (
								@CatalogID
								, @AllcatalogId
								)
							OR ',' + str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
							)
					
					AND bit_display_to_public = 1
				
				AND col1.ClassID NOT IN (
					SELECT cx.ClassID
					FROM ProgramSectionClasses cx
					GROUP BY cx.ClassID
				)
				
				

			SELECT classid
			INTO #temp3
			FROM tbl_class_listing cl1 WITH (NOLOCK)
			
			LEFT JOIN MembershipTypes mt1 
				ON mt1.MembershipTypeID IN (
					SELECT value 
					FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
				)
			WHERE 1 = 1
				AND ( 
					MemberShipTypeID = @MemberShipTypeID
					OR bit_display_classes_members_only = 0 
				)
				
					AND bit_display_to_public = 1
				

			UNION

			SELECT classid
			FROM tbl_class_listing cl1 WITH (NOLOCK)
			
			WHERE ((cl1.str_limit_self_reg_mbrship_type_ids = '')
				OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
				OR (cl1.str_limit_self_reg_mbrship_type_ids = '0'))
				AND ClassID NOT IN (
					SELECT cx.ClassID
					FROM ProgramSectionClasses cx
					GROUP BY cx.ClassID
				)
				
					AND bit_display_to_public = 1
				

			SELECT c.OrgID
				, c.RegionID
				, c.CategoryID
				, c.NAME AS CategoryName
				, sc.SubcategoryID
				, (
					SELECT ExternalCourseProviderID
					FROM ExternalCourseProvider WITH (NOLOCK)
					WHERE DefaultSubcategoryID = sc.SubCategoryID
					) AS ExternalCourseProviderID
				, sc.NAME AS SubcategoryName
				, sc.SubCategoryID AS SubCategoryID
				, sc.str_subCat_graphic AS SubCategoryImg
				, c.str_cat_graphic AS CategoryImg
				, c.SortOrder AS CategorySortOrder
				, sc.SortOrder AS SubCategorySortOrder
			FROM Categories c WITH (NOLOCK)
			LEFT JOIN SubCategories sc WITH (NOLOCK) ON c.CategoryID = sc.CategoryID
			WHERE c.STATUS = 'A'
				AND sc.STATUS = 'A'
				
				
				
				AND c.RegionID = 1 
						AND (
							EXISTS (
									SELECT subcategoryid
									FROM #temp1 t1
									WHERE t1.SubcategoryID = sc.SubCategoryID
						)
						OR sc.subcategoryid IN (
								SELECT [value]
								FROM #temp
								)
						OR sc.subcategoryid IN (
								SELECT DISTINCT CL.SubCategoryID
								FROM tbl_class_listing CL WITH (NOLOCK)
								INNER JOIN CourseSeriesGroups CSG WITH (NOLOCK) ON CSG.SeriesGroupID = CL.int_course_series_group_id
								INNER JOIN tbl_course_series_type cst WITH (NOLOCK) ON cst.int_course_series_type_id = CSG.int_course_series_type_id
								INNER JOIN tbl_class_course_series_group ccsg WITH (NOLOCK) ON ccsg.int_Series_group_id = CL.int_course_series_group_id
								LEFT JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = ccsg.int_class_id
								
									AND (CSG.bit_disp_cs_to_public = 1)
								
								WHERE @currentTimeZoneOffsetDate BETWEEN CL.AppearanceStartDate AND CL.AppearanceEndDate
									
										AND tcd.int_class_id IN (
											SELECT classid FROM #temp3
											)
									
											AND (
												SELECT count(ClassListingID)
												FROM tbl_class_listing cl2 WITH (NOLOCK)
												WHERE ccsg.int_class_id = cl2.classid
													AND (
														(
															CSG.bit_display_in = 1
															AND (
																	catalogid IN (
																	@CatalogID
																, @AllcatalogId
																)
																	OR ',' + str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
															)
															)
														OR (
															CSG.bit_display_in = 0
															AND (
																	catalogid IN (
																	@CatalogID
																, @AllcatalogId
																)
																	OR ',' + str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
															)
														)
														)
												) > 0
										
								)
						OR sc.subcategoryid IN (
								SELECT SubCategoryID
								FROM tbl_class_listing tcl WITH (NOLOCK)
								INNER JOIN tbl_certificates tc WITH (NOLOCK) ON tcl.int_certificate_id = tc.int_certificate_id
								INNER JOIN tbl_certificates_classes tcc WITH (NOLOCK) ON tcc.int_certificate_id = tc.int_certificate_id
								INNER JOIN tbl_class_detail tcd WITH (NOLOCK) ON tcd.int_class_id = tcc.int_class_id
									
										AND (tc.bit_display_to_public = 1)
									
									AND tcl.dat_publish_date IS NOT NULL
									AND tc.chr_status = 'P'
									AND (
										SELECT count(int_certificate_class_id)
										FROM tbl_certificates_classes cc WITH (NOLOCK)
										INNER JOIN tbl_class_listing cl WITH (NOLOCK) ON cc.int_class_id = cl.classid
											
													AND (
														(
															tc.bit_display_in = 1
															AND (
																	tcl.catalogid IN (
																	@CatalogID
																, @AllcatalogId
																)
																	OR ',' + str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
															)
															)
														OR (
															tc.bit_display_in = 0
															AND (
																	tcl.catalogid IN (
																	@CatalogID
																, @AllcatalogId
																)
																	OR ',' + str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
																)
															AND (
																tcl.catalogid IN (
																	SELECT catalogid
																	FROM catalogs
																	)
																OR tcl.catalogid IS NULL
																)
															)
														)
												
										) > 0
								)
						OR sc.subcategoryid IN (
								SELECT DISTINCT cl.SubCategoryID
								FROM tbl_class_listing CL WITH (NOLOCK)
								INNER JOIN tbl_certificates tc WITH (NOLOCK) ON CL.int_certificate_id = tc.int_certificate_id
									AND tc.chr_status = 'P'
								WHERE CL.str_class_type = 'cf'
									AND @currentTimeZoneOffsetDate BETWEEN CL.AppearanceStartDate
										AND CL.AppearanceEndDate
										
											AND tc.bit_display_to_public = 1
										
											AND (
												(
													tc.bit_display_in = 1
													AND (
															cl.catalogid IN (
															@CatalogID
														, @AllcatalogId
														)
															OR ',' + str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
													)
													)
												OR (
													tc.bit_display_in = 0
													AND (
															cl.catalogid IN (
															@CatalogID
														, @AllcatalogId
														)
															OR ',' + str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
														)
													AND (
														cl.catalogid IN (
															SELECT catalogid
															FROM catalogs
															)
														OR cl.catalogid IS NULL
														)
													)
												)
										
									)
						
							OR EXISTS (
									SELECT subcategoryid
									FROM #temp2
									WHERE @currentTimeZoneOffsetDate BETWEEN AppearanceStartDate
									AND AppearanceEndDate
									AND SubcategoryID = sc.SubCategoryID
									AND classid IN (SELECT classid FROM #temp3)
										
										
												AND (
													#temp2.CatalogID IN (@CatalogID)
													OR ',' + #temp2.str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
												)
											
										
									)
						
						)
					
			ORDER BY c.SortOrder
				, c.NAME
				, sc.SortOrder
				, sc.NAME
		END
		ELSE
		BEGIN
			SELECT c.OrgID
				, c.RegionID
				, c.CategoryID
				, c.NAME AS CategoryName
				, sc.SubcategoryID
				, (
					SELECT ExternalCourseProviderID
					FROM ExternalCourseProvider WITH (NOLOCK)
					WHERE DefaultSubcategoryID = sc.SubCategoryID
					) AS ExternalCourseProviderID
				, sc.NAME AS SubcategoryName
				, sc.SubCategoryID AS SubCategoryID
				, sc.str_subCat_graphic AS SubCategoryImg
				, c.str_cat_graphic AS CategoryImg
				, c.SortOrder AS CategorySortOrder
				, sc.SortOrder AS SubCategorySortOrder
			FROM Categories c WITH (NOLOCK)
			LEFT JOIN SubCategories sc WITH (NOLOCK) ON c.CategoryID = sc.CategoryID
			WHERE c.STATUS = 'A'
				AND sc.STATUS = 'A'
				AND c.RegionID = 1
				/* Filter by a list of catalog ID's */
				
				

					AND (
							/*
								First part of ShowOnlyCatSubCatWithActiveClass
								to get subcategories of classes that are active or confirmed
							*/
							EXISTS (
									SELECT subcategoryid
									FROM #temp1 t1
									WHERE t1.SubcategoryID = sc.SubCategoryID
								)
							/*
								Second part of ShowOnlyCatSubCatWithActiveClass to get subcategories of course series groups that are active
								Same conditions of membership, public display and display dates applies here as well.
								Condition is written only for public and not staff like above - why?? -
								AP: ***Fill in if you know the reason***
								AP: Probably because, if a course series group is active the associated class is active?
							*/
							
								OR 	EXISTS (
										SELECT subcategoryid
										FROM #temp2
										WHERE @currentTimeZoneOffsetDate BETWEEN AppearanceStartDate
										AND AppearanceEndDate
										AND SubcategoryID = sc.SubCategoryID
										
												AND #temp2.classid IN (
														SELECT classid
														FROM tbl_class_listing cl1 WITH (NOLOCK)
														LEFT JOIN MembershipTypes mt1 
															ON mt1.MembershipTypeID IN (
																SELECT value 
																FROM STRING_SPLIT(cl1.str_limit_self_reg_mbrship_type_ids, ',')
															)
														WHERE 1 = 1
															AND (
																MemberShipTypeID = @MemberShipTypeID 
																OR bit_display_classes_members_only = 0
															)
															
																AND (
																	Cl1.CatalogID IN (@CatalogID)
																	OR ',' + cl1.str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
																)
															

														UNION

														SELECT classid
														FROM tbl_class_listing cl1 WITH (NOLOCK)
														WHERE (cl1.str_limit_self_reg_mbrship_type_ids = '')
															OR (cl1.str_limit_self_reg_mbrship_type_ids IS NULL)
															OR (cl1.str_limit_self_reg_mbrship_type_ids = '0')
															
																AND (
																	Cl1.CatalogID IN (@CatalogID)
																	OR ',' + cl1.str_alt_catalog_ids + ',' LIKE '%,'+@AltCatalogID+',%'
																)
															
														)
											
										)
							
							/*
								Third part of ShowOnlyCatSubCatWithActiveClass to get subcategories for certificates that are active
								The dates are checeked agains appearance dates only - Probabaly needs to be written similar to first part.
							*/
							OR sc.subcategoryid IN (
								SELECT DISTINCT cl.SubCategoryID
								FROM tbl_class_listing CL WITH (NOLOCK)
								INNER JOIN tbl_certificates tc WITH (NOLOCK) ON CL.int_certificate_id = tc.int_certificate_id
									AND tc.chr_status = 'P'
								WHERE CL.str_class_type = 'cf'
									AND @currentTimeZoneOffsetDate BETWEEN CL.AppearanceStartDate AND CL.AppearanceEndDate
										
											AND tc.bit_display_to_public = 1
										
							)
						)
			
			ORDER BY c.SortOrder
				, c.NAME
				, sc.SortOrder
				, sc.NAME
		END

		IF object_id('tempdb..#temp') IS NOT NULL
		BEGIN
			DROP TABLE #temp
		END

		IF object_id('tempdb..#temp1') IS NOT NULL
		BEGIN
			DROP TABLE #temp1
		END

		IF object_id('tempdb..#temp2') IS NOT NULL
		BEGIN
			DROP TABLE #temp2
		END

		IF object_id('tempdb..#temp3') IS NOT NULL
		BEGIN
			DROP TABLE #temp3
		END

		SET NOCOUNT OFF

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-02 10:00:37.201

			    
			        Parameter #2(cf_sql_integer) = 2

			    
			        Parameter #3(cf_sql_varchar) = 2

			    
			        Parameter #4(cf_sql_integer) = 0

qCatalog (Datasource=GenooSandbox, Time=0ms, Records=7) in E:\Lumens\Versions\v81QA\SQL\GetCatalog.cfm @ 10:00:37.037

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	DECLARE @currentTimeZoneOffsetDate AS DATETIME2 = ?;

	SELECT Name
		, STATUS
		, Catalogs.CatalogID
		, SortOrder
		, CampusCode
		
		, AvailableForRequest
		, CASE 
			WHEN EXISTS (
					SELECT 'x'
					FROM Classes
					INNER JOIN tbl_class_listing tcl ON classes.classid = tcl.classid
					WHERE Classes.STATUS IN ('A','C')
						
						AND @currentTimeZoneOffsetDate BETWEEN Classes.AppearanceStartDate
							AND Classes.AppearanceEndDate
						AND tcl.bit_display_to_public = 1 
						
						AND (
							Classes.CatalogID = Catalogs.CatalogID
							OR (',' + RTRIM(tcl.str_alt_catalog_ids) + ',') LIKE '%,' + CAST(Catalogs.CatalogID AS VARCHAR) + ',%'
							)
					)
				THEN 1
			ELSE 0
			END AS ClassActive
		, CASE WHEN CatalogClsCnt.CatalogID IS NOT NULL OR AltCatalogClsCnt.CatalogID IS NOT NULL
				THEN 1
			ELSE 0
			END AS EverHadClass
		, str_catalog_display_name
		, bit_hide_from_menu AS hide_from_menu
		, dbo.fun_strip_html(Name) AS NameNoHTML
	FROM Catalogs 
	LEFT JOIN (
		SELECT COUNT(ClassID) AS Cnt
			, CatalogID
		FROM Classes
		GROUP BY CatalogId
		HAVING COUNT(ClassID) > 0
	) CatalogClsCnt ON CatalogClsCnt.CatalogID = Catalogs.CatalogID
	LEFT JOIN (
		SELECT COUNT(tcd.int_class_id) AS cnt
			, altCatalogs.value AS CatalogID
		FROM tbl_class_detail tcd
		CROSS APPLY STRING_SPLIT(tcd.str_alt_catalog_ids, ',') altCatalogs
		WHERE tcd.str_alt_catalog_ids IS NOT NULL AND TRIM(tcd.str_alt_catalog_ids) != ''
		GROUP BY altCatalogs.value
		HAVING COUNT(tcd.int_class_id) > 0
	) AltCatalogClsCnt ON AltCatalogClsCnt.CatalogID = Catalogs.CatalogID
	WHERE 1 = 1
		
			AND Status IN (?)
		
	ORDER BY SortOrder
	SET TRANSACTION ISOLATION LEVEL READ COMMITTED

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_timestamp) = 2025-08-02 10:00:37.232

			    
			        Parameter #2(cf_sql_varchar) = A

qDistinctCat (Datasource=, Time=0ms, Records=7) in E:\Lumens\Versions\v81QA\templates\courses.cfm @ 10:00:37.037

SELECT DISTINCT CategoryName FROM CatSubCatQry

qExternalCourseProvider (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\SQL\GetExternalCourseProvider.cfm @ 10:00:37.037

SELECT	ExternalCourseProvider.ExternalCourseProviderID,
			ExternalCourseProvider.DefaultSubcategoryID,
			ExternalCourseProvider.DefaultCatalogID,
			ExternalCourseProvider.IsFeatured,
			ExternalCourseProvider.FeaturedImagePath,
			Categories.CategoryID AS DefaultCategoryID,
			Subcategories.Name AS DefaultSubcategoryName,
			Categories.Name AS DefaultCategoryName,
			Subcategories.BaseCourseNumber,
			ExternalCourseProvider.CourseImportTranslationURL,
			ExternalCourseProvider.Name,
			ExternalCourseProvider.Status,
			ExternalCourseProviderType.Description AS ExternalCourseProviderTypeDescription,
			ExternalCourseProvider.ExternalCourseProviderCustomerCode,
			ExternalCourseProvider.SendRegistrationURL,
			ExternalCourseProvider.SendRegistrationEmail,
			ExternalCourseProvider.username,
			ExternalCourseProvider.password,
			ExternalCourseProvider.unit
	FROM	ExternalCourseProvider
			INNER JOIN ExternalCourseProviderType
				ON ExternalCourseProviderType.ExternalCourseProviderTypeID = ExternalCourseProvider.ExternalCourseProviderTypeID
			LEFT JOIN Subcategories
				ON ExternalCourseProvider.DefaultSubcategoryID = Subcategories.SubcategoryID
			LEFT JOIN Categories
				ON Categories.CategoryID = Subcategories.CategoryID
	WHERE	1=1
	
		AND ExternalCourseProvider.IsFeatured = 1

ContentsQry (Datasource=GenooSandbox, Time=16ms, Records=2) in E:\Lumens\Versions\v81QA\SQL\ContentsQry.cfm @ 10:00:37.037

SELECT ContentID
		, OrgID
		, RegionID
		, Section
		, Path
		, Contents
		, ContentsNoHTML
		, Description
		, Name
		, emailTemplate
		, str_default_condition
		, str_page_title
		, str_meta_description
		, str_keywords
	FROM Contents
	WHERE Path = ?
		AND	orgid = ?
		AND	regionid= ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = courses

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_integer) = 1

qCatalogName (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\templates\courses.cfm @ 10:00:37.037

SELECT NAME
					FROM Catalogs
					WHERE CatalogID IN (2)
						AND CatalogID > 0
						AND NAME <> 'All Catalogs'
					ORDER BY NAME

qCatalog (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\templates\courses.cfm @ 10:00:37.037

SELECT * FROM qCatalog WHERE ClassActive = 1

qGetText (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\textEdit.cfc @ 10:00:37.037

Declare @ContentCondition bit
			SET @ContentCondition = 1
			SELECT contents
				
				,contents.path
                ,contents.str_page_title
				,contents.str_meta_description
				,contents.str_keywords
				,contents.section
	    		,contents.str_desc_learner_erp_email
	    		,contents.str_desc_learner_no_erp_email
				
			FROM Contents
			WHERE @ContentCondition = @ContentCondition
			
			AND Path = ?
			AND section = ? 
			AND RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = courses

			    
			        Parameter #2(cf_sql_varchar) = 1

			    
			        Parameter #3(cf_sql_integer) = 1

CatalogCoursesQry (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\templates\courses.cfm @ 10:00:37.037

/*Select SubCategoryIDs where CatalogID conditions are met*/
		SELECT DISTINCT SubCategoryID
		FROM tbl_class_listing
		WHERE 1 = 1
			
				AND (
					CatalogID IN (?)
					OR EXISTS (
						SELECT 1
						FROM STRING_SPLIT(str_alt_catalog_ids, ',') AS alt
						WHERE TRIM(alt.value) IN (?)
					)
				)
			

		UNION

		/*Select individual subcategory ids from str_alt_subcategory_ids*/
		SELECT DISTINCT TRIM(value) AS SubCategoryID
		FROM tbl_class_listing
		CROSS APPLY STRING_SPLIT(str_alt_subcategory_ids, ',')
		WHERE 1 = 1
			AND str_alt_subcategory_ids IS NOT NULL AND TRIM(str_alt_subcategory_ids) != ''
			
				AND (
					CatalogID IN (?)
					OR EXISTS (
						SELECT 1
						FROM STRING_SPLIT(str_alt_catalog_ids, ',') AS alt
						WHERE TRIM(alt.value) IN (?)
					)
				)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 2

			    
			        Parameter #2(cf_sql_integer) = 2

			    
			        Parameter #3(cf_sql_integer) = 2

			    
			        Parameter #4(cf_sql_integer) = 2

CatSubCatQryFilter (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\templates\courses.cfm @ 10:00:37.037

SELECT *
		FROM CatSubCatQry
			, CatalogCoursesQry
		WHERE CatSubCatQry.SubCategoryID = CatalogCoursesQry.SubCategoryID
		ORDER BY 
			
			 CategorySortOrder
			,CategoryName
			,SubCategorySortOrder
			,SubcategoryName

qGetText (Datasource=GenooSandbox, Time=16ms, Records=1) in E:\Lumens\versions\v81QA\cfc\textEdit.cfc @ 10:00:37.037

Declare @ContentCondition bit
			SET @ContentCondition = 1
			SELECT contents
				
				,contents.path
                ,contents.str_page_title
				,contents.str_meta_description
				,contents.str_keywords
				,contents.section
	    		,contents.str_desc_learner_erp_email
	    		,contents.str_desc_learner_no_erp_email
				
			FROM Contents
			WHERE @ContentCondition = @ContentCondition
			
			AND Path = ?
			AND section = ? 
			AND RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = courses

			    
			        Parameter #2(cf_sql_varchar) = 2

			    
			        Parameter #3(cf_sql_integer) = 1

qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 10:00:37.037

select * from qSocialMedia order by int_order desc

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:\Lumens\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=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=AWSALBAPP-0=AAAAAAAAAABpEZ17ovT+u5KSUfOn2sSQuLhxMAntKTel2m6ZyNkQGQcT+OqTctRWesd4vDXDqkfJxub2hxZc5ku0TDqwo4VnTP+ut7sgQs5TP/CK8ElVfcMT5Xs6MsHd8EN+14N45B/E8Q==; JSESSIONID=7D3521CBAA9AD1303CA9F155788F7DD0.cfusion; AWSALBAPP-1=_remove_; AWSALBAPP-2=_remove_; AWSALBAPP-3=_remove_; LUMPERSIST=D910BB8E72DACBC1C189A12FA9EF4A73
HTTP_HOST=genoosandbox.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm?catalogid=2&fuseaction=1010
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.100.167
PATH_INFO=
PATH_TRANSLATED=E:\Lumens\index.cfm
QUERY_STRING=catalogid=2&fuseaction=1010
REMOTE_ADDR=172.31.102.40
REMOTE_HOST=172.31.102.40
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=genoosandbox.augusoft.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
AWSALBAPP-0=AAAAAAAAAABpEZ17ovT u5KSUfOn2sSQuLhxMAntKTel2m6ZyNkQGQcT OqTctRWesd4vDXDqkfJxub2hxZc5ku0TDqwo4VnTP ut7sgQs5TP/CK8ElVfcMT5Xs6MsHd8EN 14N45B/E8Q
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
JSESSIONID=7D3521CBAA9AD1303CA9F155788F7DD0.cfusion
LUMPERSIST=D910BB8E72DACBC1C189A12FA9EF4A73

Session Variables:
actortypeid=90
addtoken=CFID=18642180&CFTOKEN=bcf4c51f4f9f33b0-30FD76D2-0E92-86E5-4F9752E269A0D54C&jsessionid=7D3521CBAA9AD1303CA9F155788F7DD0.cfusion
allowunmaskeddata=0
appname=GenooSandbox
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.GenooSandbox
customerid=325
custompath=/Customers/GenooSandbox/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=genoosandbox.augusoft.net
ds=GenooSandbox
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=216.73.216.8
foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
loggedin=No
loggeduseremail=
loggeduserfname=Guest
loggeduserlname=
membershiptypeid=0
menuid=1
orgid=1
privacypolicyack=
regionid=1
sessionid=7D3521CBAA9AD1303CA9F155788F7DD0.cfusion
sitepath=/Customers/GenooSandbox
sslreturnurl=https://genoosandbox.augusoft.net/
stylesheetpath=/Customers/GenooSandbox/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=18642185&CFTOKEN=fb20babc8454d5fb-30FD9701-EA00-93BA-2AF930655C981221&jsessionid=7D3521CBAA9AD1303CA9F155788F7DD0.cfusion
version=v81QA

URL Parameters:
catalogid=2
fuseaction=1010

Debug Rendering Time: 15 ms

Shopping cart is empty !

You are not logged in.

Courses