Survey Datasets Files

Cote d'Ivoire: Standard DHS, 1994
This page shows a listing of all dataset files available for the selected survey.
If you are a registered user, please login here to gain access to these files.
If you are not a registered user, please go here to register.
Survey Datasets
File Name File Size File Format
Births Recode
CIBR35dt.zip 2.52 MB Stata dataset (.dta)
CIBR35FL.zip 2.85 MB Flat ASCII data (.dat)
CIBR35sd.zip 3.74 MB SAS dataset (.sas7bdat)
CIBR35sv.zip 4.12 MB SPSS dataset (.sav)
Couples' Recode
CICR35DT.ZIP 643 KB Stata dataset (.dta)
CICR35FL.ZIP 782 KB Flat ASCII data (.dat)
CICR35SD.ZIP 864 KB SAS dataset (.sas7bdat)
CICR35SV.ZIP 706 KB SPSS dataset (.sav)
Household Recode
CIHR35DT.ZIP 608 KB Stata dataset (.dta)
CIHR35FL.ZIP 731 KB Flat ASCII data (.dat)
CIHR35SD.ZIP 877 KB SAS dataset (.sas7bdat)
CIHR35SV.ZIP 687 KB SPSS dataset (.sav)
Height and Weight Scores - WHO Child Growth Standards
CIHW35.ZIP 49.1 KB Hierarchical ASCII data (.dat)
CIHW35DT.ZIP 46.8 KB Stata dataset (.dta)
CIHW35FL.ZIP 50.9 KB Flat ASCII data (.dat)
CIHW35SD.ZIP 52.5 KB SAS dataset (.sas7bdat)
CIHW35SV.ZIP 50.2 KB SPSS dataset (.sav)
Individual Recode
CIIR35.ZIP 3.45 MB Hierarchical ASCII data (.dat)
CIIR35DT.ZIP 3.06 MB Stata dataset (.dta)
CIIR35FL.ZIP 3.47 MB Flat ASCII data (.dat)
CIIR35SD.ZIP 4.88 MB SAS dataset (.sas7bdat)
CIIR35SV.ZIP 3.43 MB SPSS dataset (.sav)
Children's Recode
CIKR35DT.ZIP 1.52 MB Stata dataset (.dta)
CIKR35FL.ZIP 1.68 MB Flat ASCII data (.dat)
CIKR35SD.ZIP 1.99 MB SAS dataset (.sas7bdat)
CIKR35SV.ZIP 1.78 MB SPSS dataset (.sav)
Men's Recode
CIMR33.ZIP 471 KB Hierarchical ASCII data (.dat)
CIMR33DT.ZIP 385 KB Stata dataset (.dta)
CIMR33FL.ZIP 444 KB Flat ASCII data (.dat)
CIMR33SD.ZIP 511 KB SAS dataset (.sas7bdat)
CIMR33SV.ZIP 441 KB SPSS dataset (.sav)
Household Member Recode
CIPR35DT.ZIP 593 KB Stata dataset (.dta)
CIPR35FL.ZIP 674 KB Flat ASCII data (.dat)
CIPR35SD.ZIP 789 KB SAS dataset (.sas7bdat)
CIPR35SV.ZIP 1.01 MB SPSS dataset (.sav)
Service Availability Raw
CISQ33.ZIP 60.6 KB Hierarchical ASCII data (.dat)
CISQ33DT.ZIP 55.1 KB Stata dataset (.dta)
CISQ33FL.ZIP 88.6 KB Flat ASCII data (.dat)
CISQ33SD.ZIP 87.5 KB SAS dataset (.sas7bdat)
CISQ33SV.ZIP 57.1 KB SPSS dataset (.sav)
Wealth Index
CIWI34.ZIP 35.3 KB Hierarchical ASCII data (.dat)
CIWI34DT.ZIP 29.4 KB Stata dataset (.dta)
CIWI34FL.ZIP 36.1 KB Flat ASCII data (.dat)
CIWI34SD.ZIP 39.4 KB SAS dataset (.sas7bdat)
CIWI34SV.ZIP 46.0 KB SPSS dataset (.sav)
Geographic Datasets
File Name File Size File Format
Geographic Data
CIGE33FL.ZIP 27.3 KB Shape file (.shp)
Geospatial Covariates
CIGC32FL.ZIP 747 KB Comma delimited data (.csv)


Debugging Information
ColdFusion Server Standard 2018,0,19,330149
Template /data/dataset/Cote-d-Ivoire_Standard-DHS_1994.cfm
Time Stamp 18-Sep-24 08:35 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.0.0.213
Host Name 10.0.0.213


Execution Time

Total Time Avg Time Count Template
1222 ms 45 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
1176 ms 44 ms 27 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
738 ms 738 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
738 ms 738 ms 1 C:/inetpub/wwwroot/dhs/data/dataset/Cote-d-Ivoire_Standard-DHS_1994.cfm
629 ms 629 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
614 ms 614 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
614 ms 614 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
614 ms 614 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
614 ms 614 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
579 ms 58 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
579 ms 579 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
250 ms 250 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c1378-l70-t51-dAny.read
219 ms 219 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c8022-l70-t51-dAny.read
188 ms 188 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
141 ms 141 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
93 ms 93 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/data/dataset_detail_display.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
48 ms 48 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19153-l70-t51-dAny.read
48 ms 24 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(8153, 8024) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
47 ms 47 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19152-l70-t51-dAny.read
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
32 ms 32 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19155-l70-t51-dAny.read
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19154-l70-t51-dAny.read
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
19 ms 19 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c1432-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19169-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-stub.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/data/dataset/Application.cfm
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
15 ms 1 ms 13 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(8153) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
4 ms 4 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/34/p8153-c19177-l70-t51-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/dhtmlmenu/menu-output-display.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/browser-detect-methods.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/style/load-page-classes.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/upfront-ghost-queries.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/item-visible.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/survey/countries_functions.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/data/dataset/template-dataset-access.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2352) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(8021) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(8153) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(1, 1, 0, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(8021, 34, 2352, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(8153, 34, 8021, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 34, 8153, 8021, 0, 0, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomAppPath(34) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomModulePath(post-page-render, 34) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc | GetEntry(8153) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc | getRewriteSettings(34) ] from C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(template-dataset-access.cfm, 8021, 34) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc | executeFunction(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(New (global) session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(RequestTimeout check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Server-level remote requests checked) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Subsite context updated (ID=34)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(customerScope object initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user object created) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Cache) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Element) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(LiveBookmarks) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(8153, 34) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 8153) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
769 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get (Datasource=dhs_legacy_live, Time=0ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 20:35:35.035
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
GetPageRec (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\verify-stub-data.cfm @ 20:35:35.035
		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

GetPageRec (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\build-and-write-stub.cfm @ 20:35:35.035
	SELECT *
	  FROM SitePages
	 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

inheritedCacheSettings (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 20:35:35.035
		SELECT StaleCacheMaxKeepTime,DynamicContentCacheKeepTime
		  FROM SitePages
		 WHERE (ID IN (?,?,?,?)) 
	 ORDER BY ID
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8021

GetBaseTemplateSubSiteID (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 20:35:35.035
		SELECT DISTINCT SitePages.SubSiteID
		  FROM SitePages, Subsites
		 WHERE SitePages.SubSiteID = Subsites.ID
		
			AND Subsites.ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

qParentTemplateInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 20:35:35.035
			SELECT PageType
			  FROM SitePages
			 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8021

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 20:35:35.035
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

qryKeywords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\keywords-tags\keywords-tags-base.cfc @ 20:35:35.035
		SELECT OriginalString AS Word 
				, KeywordType As KeywordTypeID
				
		  FROM ObjectKeywords
		 WHERE ObjectID = ? 
			AND KeywordType = ? 
	 ORDER BY Position, OriginalString
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153
Parameter #2(CF_SQL_TINYINT) = 0

GetRenderOptions (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 20:35:35.035
			SELECT GeneralCategories.Category, RenderOptions.PageID
			  FROM RenderOptions, GeneralCategories
			 WHERE GeneralCategories.ID = RenderOptions.CategoryID
				AND GeneralCategories.CategoryTypeID = ?
				AND (RenderOptions.PageID IN (?,?,?,?,?)) 
		 ORDER BY RenderOptions.PageID Desc
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 12
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 2352
Parameter #5(CF_SQL_INTEGER) = 8153
Parameter #6(CF_SQL_INTEGER) = 8021

getPageInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 20:35:35.035
	SELECT PageType, SubSiteID, CategoryID, InheritedTemplateList, DocType, Uploaded
	  FROM SitePages
	 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

FormData (Datasource=commonspot-site-dhs, Time=47ms, Records=16) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 20:35:35.035
	SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue, FormInputControl.FieldName, FormInputControl.type, FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid, FormInputControl.params AS fieldParams
						  
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE (Data_FieldValue.PageID IN (?,?,?,?,?))  
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
	
		
		AND (
				
				(
					(FormControlMap.ClassConstant = 4)
				
					AND (FormControlMap.ClassID IN (?,?,?)) 
				)
				
				
					OR (
								 (FormControlMap.ClassConstant = 1)
							AND ( (FormControlMap.ClassID IN (?,?,?,?)) )
						)
				
				
					OR (
								 (FormControlMap.ClassConstant = 2)
							AND (FormControlMap.ClassID = ?)
						)
				
				

				
			 )
	
 ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8153
Parameter #5(CF_SQL_INTEGER) = 8021
Parameter #6(CF_SQL_INTEGER) = 34
Parameter #7(CF_SQL_INTEGER) = 1
Parameter #8(CF_SQL_INTEGER) = 5
Parameter #9(CF_SQL_INTEGER) = 1
Parameter #10(CF_SQL_INTEGER) = 2
Parameter #11(CF_SQL_INTEGER) = 2352
Parameter #12(CF_SQL_INTEGER) = 8021
Parameter #13(CF_SQL_INTEGER) = 1

NamedClasses (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\style\load-page-classes.cfm @ 20:35:35.035
	SELECT *
	  FROM Data_ClassNames
	 WHERE (PageID IN (?,?,?,?,?)) 
		AND VersionState = ?
		AND OutputTypeID = 0
 ORDER BY PageID DESC, ControlID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8153
Parameter #5(CF_SQL_INTEGER) = 8021
Parameter #6(CF_SQL_INTEGER) = 2

StyleSheetGroups (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 20:35:35.035
		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8153
Parameter #5(CF_SQL_INTEGER) = 8021
Parameter #6(CF_SQL_INTEGER) = 2

PageStyleSheets (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 20:35:35.035
		SELECT *
		  FROM Data_StyleSheets
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND ControlID = ?
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8153
Parameter #5(CF_SQL_INTEGER) = 8021
Parameter #6(CF_SQL_INTEGER) = 3474
Parameter #7(CF_SQL_INTEGER) = 2

CheckCustomRender (Datasource=commonspot-site-dhs, Time=0ms, Records=67) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 20:35:35.035
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8153
Parameter #5(CF_SQL_INTEGER) = 8021
Parameter #6(CF_SQL_INTEGER) = 2

SecurityRecords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 20:35:35.035
	SELECT DISTINCT ControlID
	  FROM ItemSecurity
	 WHERE PageID = ?
		AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

ParentTemplateInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\write-stub.cfm @ 20:35:35.035
		SELECT SubsiteID,Filename,PageType
		  FROM SitePages
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8021

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=2663) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 20:35:35.035
		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8153
Parameter #5(CF_SQL_INTEGER) = 8021
Parameter #6(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 20:35:35.035
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=8153 OR (PageID IN (8021,2352,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		
qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 20:35:35.035
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 20:35:35.035
		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153
Parameter #2(CF_SQL_INTEGER) = 11

Request.GetGhost (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\upfront-ghost-queries.cfm @ 20:35:35.035
	SELECT *
	  FROM Data_Ghost_Common
	 WHERE (PageID=8153 OR (PageID IN (8021,2352,2,1) AND (VersionState = 2)))
	ORDER BY ControlID, PageID DESC
ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=80) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 20:35:35.035
		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 2352
Parameter #4(CF_SQL_INTEGER) = 8153
Parameter #5(CF_SQL_INTEGER) = 8021

qInfo (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 20:35:35.035
		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 400
Parameter #2(CF_SQL_INTEGER) = 22
Parameter #3(CF_SQL_INTEGER) = 44
Parameter #4(CF_SQL_INTEGER) = 55
Parameter #5(CF_SQL_INTEGER) = 1
Parameter #6(CF_SQL_INTEGER) = 56
Parameter #7(CF_SQL_INTEGER) = 47
Parameter #8(CF_SQL_INTEGER) = 26
Parameter #9(CF_SQL_INTEGER) = 48
Parameter #10(CF_SQL_INTEGER) = 27
Parameter #11(CF_SQL_INTEGER) = 28
Parameter #12(CF_SQL_INTEGER) = 51
Parameter #13(CF_SQL_INTEGER) = 31
Parameter #14(CF_SQL_INTEGER) = 33
Parameter #15(CF_SQL_INTEGER) = 26
Parameter #16(CF_SQL_INTEGER) = 48
Parameter #17(CF_SQL_INTEGER) = 37
Parameter #18(CF_SQL_INTEGER) = 27
Parameter #19(CF_SQL_INTEGER) = 38
Parameter #20(CF_SQL_INTEGER) = 28
Parameter #21(cf_sql_integer) = 26

Request.customCFUpfront (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 20:35:35.035
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=8153 OR (PageID IN (8021,2352,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 20:35:35.035
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

testQuery (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8021

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2352

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = BR

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = CR

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = HR

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = HW

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = .Z

getFileformat_hier (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
	      SELECT * FROM File_For where File_for_id = 1 
	     
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = IR

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = .Z

getFileformat_hier (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
	      SELECT * FROM File_For where File_for_id = 1 
	     
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=15ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = KR

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MR

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = .Z

getFileformat_hier (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
	      SELECT * FROM File_For where File_for_id = 1 
	     
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = PR

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SQ

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = .Z

getFileformat_hier (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
	      SELECT * FROM File_For where File_for_id = 1 
	     
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
					  SELECT File_Data_Type_Name
					  FROM File_Data_Type
					  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = WI

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = .Z

getFileformat_hier (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
	      SELECT * FROM File_For where File_for_id = 1 
	     
getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = DT

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SD

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SV

qSPADatasets (Datasource=, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
select name, size, 1 as scode
from qSPADatasets
where name like '%SR.ZIP%'

UNION

select name, size, 2 as scode
from qSPADatasets
where name like '%SP.ZIP%'

order by scode, name
getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
			  SELECT File_Data_Type_Name
			  FROM File_Data_Type
			  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GE

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

getDataType (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035
			  SELECT File_Data_Type_Name
			  FROM File_Data_Type
			  WHERE File_Data_Type_Code =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = GC

getFileformat (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\countries_functions.cfm @ 20:35:35.035
      SELECT * FROM File_For where File_for_code = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = FL

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 20:35:35.035
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8153

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8021

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2352

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 20:35:35.035
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

CacheUpdate (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 20:35:36.036
					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_VARCHAR) = 2124-09-18 20:35:35
Parameter #3(CF_SQL_VARCHAR) = 2124-09-18 20:35:35
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 0
Parameter #6(CF_SQL_VARCHAR) =
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 2
Parameter #10(CF_SQL_INTEGER) = 0
Parameter #11(CF_SQL_INTEGER) = 0
Parameter #12(CF_SQL_INTEGER) = 0
Parameter #13(CF_SQL_INTEGER) = 0
Parameter #14(CF_SQL_INTEGER) = 0
Parameter #15(CF_SQL_VARCHAR) =
Parameter #16(CF_SQL_INTEGER) = 1
Parameter #17(CF_SQL_INTEGER) = 34
Parameter #18(CF_SQL_INTEGER) = 8153
Parameter #19(CF_SQL_INTEGER) = 0
Parameter #20(CF_SQL_INTEGER) = 2
Parameter #21(CF_SQL_INTEGER) = 0


Stored Procedures

sp_dataset_disp (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\data\dataset_detail_display.cfm @ 20:35:35.035

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  62    
    
resultsets
nameresultset
 qMetadata  1
 qDatasets  2
 qGPSDatasets  3
 qHIVDatasets  4
 qSPADatasets  5


Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (34)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (7)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-09-18 19:49:32
serverclockcheck=2024-09-04 20:02:17
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\data\dataset\Cote-d-Ivoire_Standard-DHS_1994.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=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/data/dataset/Cote-d-Ivoire_Standard-DHS_1994.cfm?flag=0
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\data\dataset\Cote-d-Ivoire_Standard-DHS_1994.cfm
QUERY_STRING=flag=0
REMOTE_ADDR=10.0.0.213
REMOTE_HOST=10.0.0.213
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/data/dataset/Cote-d-Ivoire_Standard-DHS_1994.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CSRFTOKEN=C8436D97C300D55ED293B3FC11EFD083259FCE55
Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=24
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=1769573264
cs_runningdashboardcmdcode=0
csrftoken=C8436D97C300D55ED293B3FC11EFD083259FCE55
ctrl_data=Struct (79)
customcf_data=Struct (2)
customcfupfront=Query (2)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
data_ghost=Struct (0)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-09-18 20:35:35
getghost=Query (0)
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1726691735424
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (2)
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (85)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (5)
params_formfields=
params_urlfields=flag
parentisbasetemplate=0
parenttemplate=Struct (3)
previewmode=0
readmodewhereclause=(VersionState = 2)
rebuilt_stubs=
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-09-18 20:35:35.424
req_sequenceid=342705
req_startticks=1726691735424
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_4572718DB3ED175B9FDE9BE622E7236E.cfusion
sessionstring=1_4572718DB3ED175B9FDE9BE622E7236E.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=34
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-09-18 20:35:35'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (31)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=MYsXW98072w1hKIa6BHuuw==
SURVEYINFO_ACTIVE_DATE=2024-9-25
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=C8436D97C300D55ED293B3FC11EFD083259FCE55
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=8153
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1726691735424
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=4572718DB3ED175B9FDE9BE622E7236E.cfusion
sessionstring=1_4572718DB3ED175B9FDE9BE622E7236E.cfusion
urltoken=CFID=8215176&CFTOKEN=e019f40753fb8cb7-4478D0E2-D804-7AB2-505F1BDA37890084&jsessionid=4572718DB3ED175B9FDE9BE622E7236E.cfusion
usagelist=
user=Struct (31)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
flag=0
Debug Rendering Time: 31 ms