Press Releases

Sep 02, 2020
COVID-19 Update: Some DHS surveys return to the field; others postponed until 2021

COVID-19 Update: Some DHS surveys return to the field; others postponed until 2021

After a several-months pause in field activities, some DHS Program surveys will return to data collection, while others have postponed all activities until 2021. Many new DHS Program surveys are tentatively moving ahead with survey and questionnaire design, in the hopes that fieldwork will be possible later in 2020 or early 2021. The DHS Program staff based in Rockville, Maryland USA are supporting these activities remotely with the support of excellent partners and consultants in our survey countries.

Read more
Sep 02, 2020
Mise à jour COVID-19 : Certaines enquêtes DHS reprennent leurs activités de terrain ; d’autres sont reportées à 2021

Mise à jour COVID-19 : Certaines enquêtes DHS reprennent leurs activités de terrain ; d’autres sont reportées à 2021

Après un arrêt de plusieurs mois des activités de terrain, certaines enquêtes de The DHS Program vont reprendre la collecte des données, alors que d’autres ont suspendu leurs activités jusqu’en 2021. Beaucoup de nouvelles enquêtes de The DHS Program ont avancé dans certaines phases comme la conception de l’enquête et des questionnaires, dans l’espoir que le travail sur le terrain sera de nouveau possible fin 2020 ou au début de 2021. Le personnel de The DHS Program basé à Rockville, Maryland USA, travaillent à distance pour mener ces activités en bénéficiant du support d’excellents partenaires et consultants dans les pays réalisant des enquêtes démographiques et de santé (EDS).

Read more
Apr 09, 2020
COVID-19 Response: DHS Program Fieldwork Activities on Hold

In response to the COVID-19 pandemic, The DHS Program, USAID, and our partnering host-country governments have paused in-person trainings, pre-tests, and data collection activities. These actions are taken to protect the health of our fieldworkers and survey respondents, as well as to allow Ministries of Health and other national agencies to prioritize pandemic mitigation activities at this time.

Read more
Apr 09, 2020
Mise à jour COVID-19 : Activités de terrain de The DHS Program suspendues

En réponse à la pandémie du COVID-19, The DHS Program, l’USAID, et les gouvernements et les pays partenaires ont suspendu les activités dans le domaine de la formation du personnel, des prétests et de la collecte des données. Ces actions sont prises pour protéger la santé du personnel de terrain et des enquêtés, et pour permettre aux Ministères de la santé et autres agences nationales de donner la priorité aux activités qui peuvent, à ce stade, atténuer les effets de la pandémie.

Read more
Oct 16, 2018
ICF Wins $200 Million Contract to Conduct Demographic and Health Surveys

ICF (NASDAQ:ICFI), a global consulting and digital services provider, was awarded a re-compete contract by the U.S. Agency for International Development (USAID) to continue to implement its Demographic and Health Surveys Program (DHS). The contract, which was awarded by the Bureau for Global Health, has a contract value of over $200 million and a term of five years.

Read more


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /Who-We-Are/News-Room/Press-Releases.cfm
Time Stamp 03-Jul-24 01:29 AM
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.149
Host Name 10.0.0.149


Execution Time

Total Time Avg Time Count Template
3000 ms 94 ms 32 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
2984 ms 93 ms 32 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
1734 ms 1734 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
1734 ms 1734 ms 1 C:/inetpub/wwwroot/dhs/Who-We-Are/News-Room/Press-Releases.cfm
1688 ms 1688 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
1610 ms 1610 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
1610 ms 1610 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
1610 ms 1610 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
1610 ms 1610 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
1578 ms 143 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
1578 ms 1578 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
1251 ms 626 ms 2 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
1110 ms 555 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/cpe-pageindex.cfm
1094 ms 547 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/main.cfm
938 ms 469 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/query-loop.cfm
734 ms 367 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/pageindex-pre-render.cfm
719 ms 719 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c1378-l70-t51-dAny.read
610 ms 610 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c1433-l70-t51-dAny.read
156 ms 78 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/query-and-params.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
63 ms 32 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | runQuery() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
47 ms 24 ms 2 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/dhs/renderhandlers/pageIndex_pressRelease_abstract.cfm
46 ms 46 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
32 ms 16 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(1505, 9408) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19152-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19154-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19169-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19174-l70-t51-dAny.read
16 ms 8 ms 2 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load.cfm
16 ms 8 ms 2 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load_core.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
16 ms 4 ms 4 C:/inetpub/wwwroot/commonspot/utilities/ct-extract-wddx-data.cfm
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | genCommonClause() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 36) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(1505) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc | getStructure(Press Release, *, 28953) ] from C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | getRenderedHTML() ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c1432-l70-t51-dAny.read
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19153-l70-t51-dAny.read
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19155-l70-t51-dAny.read
15 ms 3 ms 6 C:/inetpub/wwwroot/commonspot/components/query-engine/render-clause.cfm
15 ms 2 ms 9 C:/inetpub/wwwroot/commonspot/components/query-engine/render-extrafilter.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/upfront-ghost-queries.cfm
15 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
15 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(1505, 4822) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc | getStructure(Press Release, *, 105158) ] from C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c19177-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/18/p1505-c51721-l70-t27356-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-get-inheritance.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/default-mode.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/dhtmlmenu/menu-output-display.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/cache-query.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/get-expand-icon-urls.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/get-params.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/controls/pageindex/param-override-with-passedin.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-metatags.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/site-application.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/site-application-meat.cfm
0 ms 0 ms 9 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 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 14 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.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 4 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/Who-We-Are/News-Room/Application.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/renderhandlers/pressReleaseList.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms 0 ms 4 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 4 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1501) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 4 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(1505) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 4 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 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(1501, 17, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(1505, 18, 1501, 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 | UpdateStatus([complex value], [complex value], 18, 1505, 1501, 0, 0, 90) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 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(18) ] 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, 18) ] 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(1505) ] 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(18) ] 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 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(1501) ] 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-who-we-are.cfm, 1501, 17) ] 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 2 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 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.ApprovalStatus, 0, int) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.AudienceID, 0, int) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.PageSetID, 0, int) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.SubSiteID, 0, int, <>) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addCategory(0) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addExtraFilter(Availability) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addExtraFilter(ExcludeExpired) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addExtraFilter(ExcludeFuture) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addExtraFilter(PageType, [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addFormat(0) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addJoin(GeneralCategories.CategoryTypeID, 1) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addJoin(GeneralCategories.ID, SitePages.CategoryID) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addKeyword() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addOwner(0) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addParentTemplate(4727) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 6 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | getObject() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 6 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | init(pageindex) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | config(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | genStandardClause() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | initTypedCacheInfo(1505, 4822, 0) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | initTypedCacheInfo(1505, 9408, 0) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | setFacetNavControl(1505, 0, true) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | chkCategorization() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | chkSortOrder() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | getCategorizedColumns() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | getOrderBy() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | getRenderMethods() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | init(0, 7, desc) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.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(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=18)) ] 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(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 4 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 270 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/visitor-context-rule-actions.cfc | onPageVisit(1505, 18) ] 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 2 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | BuildLargeInClause(1000042,1000042,1000006,1000006,1000006,1000034,1000041,1000042,1000041,1000042,1000041,1000041,1000041,1000042,1000042,1000042,1000042,1000041,1000042,1000041,1000042,1000042,1000006,1000006,1000042,1000042,1000042,1000042,1000042,1000041,1000041,1000042,1000042,1000042,1000042,1000042,1000008,1000041,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000006,1000006,1000006,1000006,1000006,1000034,1000034,1000006,1000034,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000034,1000034,1000008, ContactID) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | BuildLargeInClause(1000042,1000042,1000006,1000006,1000006,1000034,1000041,1000042,1000041,1000042,1000041,1000041,1000041,1000042,1000042,1000042,1000042,1000041,1000042,1000041,1000042,1000042,1000006,1000006,1000042,1000042,1000042,1000042,1000042,1000041,1000041,1000042,1000042,1000042,1000042,1000042,1000008,1000041,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000008,1000006,1000006,1000006,1000006,1000006,1000034,1000034,1000006,1000034,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000006,1000034,1000034,1000008, ID) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc | getStructure(Press Release, *, 105149) ] from C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc | getStructure(Press Release, *, 61895) ] from C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc | getStructure(Press Release, *, 61897) ] from C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc | init() ] from C:/inetpub/wwwroot/dhs/customcf/CommonSpotCustomElement.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | getEndRow() ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | getStartRow() ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | init() ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setArrayToPaginate([complex value]) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setBaseLink(/Who-We-Are/News-Room/Press-Releases.cfm) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setItemsPerPage(5) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setNextLinkDisabledHTML(Next &gt;&gt;) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setNextLinkHTML(Next &gt;&gt;) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setNumericDistanceFromCurrentPageVisible(2) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setPreviousLinkDisabledHTML(&lt;&lt; Previous) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setPreviousLinkHTML(&lt;&lt; Previous) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setShowNumericLinks(true) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/customcf/pagination.cfc | setUrlPageIndicator(page) ] from C:/inetpub/wwwroot/dhs/customcf/pagination.cfc
32 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1766 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=46ms, Records=2965) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 01:29:36.036
		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) = 1501
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1505
Parameter #5(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 01:29:36.036
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=1505 OR (PageID IN (1501,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 @ 01:29:36.036
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1505

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

qry (Datasource=commonspot-site-dhs, Time=16ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 01:29:36.036
		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) = 1505
Parameter #2(CF_SQL_INTEGER) = 11

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=118) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 01:29:36.036
		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) = 1501
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 1505

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 01:29:36.036
		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) = 36

getForms (Datasource=commonspot-site-dhs, Time=16ms, Records=0) in C:\inetpub\wwwroot\commonspot\metadata\tags\form_control\load_core.cfm @ 01:29:36.036
		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 4789 ORDER BY d1.id, d2.id 
GetWDDXData (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:29:36.036
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=1505 AND (VersionState = 2)) OR ((PageID IN (1501,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4822
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 36

GetWDDXData (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:29:36.036
		SELECT *
		  FROM Param_WDDX
		 WHERE PageID=0
			AND ControlID=0
			AND ItemID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 36

GetWDDXData (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:29:36.036
	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=1505 AND (VersionState = 2)) OR ((PageID IN (1501,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4822
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 36

NextTimestamp (Datasource=commonspot-site-dhs, Time=16ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\query-engine\page-core.cfc @ 01:29:36.036
			SELECT PublicReleaseDate
			  FROM SitePages
			 WHERE (PublicReleaseDate is NOT NULL AND PublicReleaseDate <> '')
				AND PublicReleaseDate > ?
			 ORDER BY PublicReleaseDate 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2024-07-03 01:29:36

GetChildren (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\page.cfm @ 01:29:36.036
			SELECT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
				AND PageID IN (SELECT ID
									  FROM SitePages
									 WHERE PageType=?)

			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4727
Parameter #2(CF_SQL_INTEGER) = 1

pageIndexQuery (Datasource=commonspot-site-dhs, Time=32ms, Records=134) in C:\inetpub\wwwroot\commonspot\components\query-engine\page-index.cfc @ 01:29:36.036
			SELECT SitePages.*,GeneralCategories.Category 
				,UploadedDocs.PublicFileName
		
			  FROM GeneralCategories,SitePages 
			LEFT OUTER JOIN UploadedDocs ON UploadedDocs.PageID = SitePages.ID AND UploadedDocs.VersionState = 2
		
			 WHERE
			
		SitePages.PublicReleaseDate <? AND 	
		(SitePages.ExpDate >= ?
			OR	(SitePages.ExpDate is NULL or SitePages.ExpDate = ''))
	AND GeneralCategories.ID = SitePages.CategoryID AND GeneralCategories.CategoryTypeID = 1 AND SitePages.AudienceID = ? AND SitePages.SubSiteID <> ? AND SitePages.PageSetID = ? AND SitePages.ApprovalStatus = ? AND 
		( (SitePages.PageType IN (?,?,?,?)) 
		)
		AND 
		( (SitePages.IsPublic IN (?,?,?,?,?,?,?,?)) 
		)
	AND 
			(
			SitePages.ID IN 
		(
			SELECT DISTINCT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
		)
	
			)
			
				ORDER BY SitePages.PublicReleaseDate desc,SitePages.title desc,SitePages.ID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2024-07-03 01:29:36
Parameter #2(CF_SQL_VARCHAR) = 2024-07-03 01:29:36
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 0
Parameter #6(CF_SQL_INTEGER) = 0
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 14
Parameter #9(CF_SQL_INTEGER) = 6
Parameter #10(CF_SQL_INTEGER) = 8
Parameter #11(CF_SQL_INTEGER) = 11
Parameter #12(CF_SQL_INTEGER) = 1
Parameter #13(CF_SQL_INTEGER) = 13
Parameter #14(CF_SQL_INTEGER) = 3
Parameter #15(CF_SQL_INTEGER) = 15
Parameter #16(CF_SQL_INTEGER) = 5
Parameter #17(CF_SQL_INTEGER) = 7
Parameter #18(CF_SQL_INTEGER) = 9
Parameter #19(CF_SQL_INTEGER) = 4727

GetOwners (Datasource=commonspot-users, Time=0ms, Records=5) in C:\inetpub\wwwroot\commonspot\controls\pageindex\query-and-params.cfm @ 01:29:36.036
		SELECT DISTINCT ContactID, FullName2 AS fullname
		  FROM UserFullNames
		 WHERE (ContactID IN (1000006,1000008,1000034,1000041,1000042))
		 
		 	UNION
		
		SELECT DISTINCT ID as ContactID, GroupName AS fullname
		  FROM idgroup
		 WHERE (ID IN (1000006,1000008,1000034,1000041,1000042)) 
GetDocType (Datasource=commonspot-site-dhs, Time=0ms, Records=79) in C:\inetpub\wwwroot\commonspot\controls\pageindex\query-and-params.cfm @ 01:29:36.036
		SELECT *
		  FROM Formats
	
getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:36.036
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 4789

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:29:37.037
		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 @ 01:29:37.037
		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

formSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID
			FROM FormControl
			WHERE FormName = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Press Release

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID
			FROM FormInputControlMap
			WHERE FormID = ?
			ORDER BY FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID, FieldName
			FROM FormInputControl
			WHERE ID IN (4757,4758,10939,10940)
			ORDER BY ID ASC
		
rtnVal (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID, FieldValue, MemoValue, FormID, PageID
			FROM Data_FieldValue
			WHERE FormID = ?
			AND VersionState = 2
			AND FieldID IN (4757,4758,10939,10940) AND PageID IN (105149)
			ORDER BY PageID, FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID
			FROM FormControl
			WHERE FormName = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Press Release

formControlSelect (Datasource=commonspot-site-dhs, Time=15ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID
			FROM FormInputControlMap
			WHERE FormID = ?
			ORDER BY FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID, FieldName
			FROM FormInputControl
			WHERE ID IN (4757,4758,10939,10940)
			ORDER BY ID ASC
		
rtnVal (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID, FieldValue, MemoValue, FormID, PageID
			FROM Data_FieldValue
			WHERE FormID = ?
			AND VersionState = 2
			AND FieldID IN (4757,4758,10939,10940) AND PageID IN (105158)
			ORDER BY PageID, FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID
			FROM FormControl
			WHERE FormName = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Press Release

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID
			FROM FormInputControlMap
			WHERE FormID = ?
			ORDER BY FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID, FieldName
			FROM FormInputControl
			WHERE ID IN (4757,4758,10939,10940)
			ORDER BY ID ASC
		
rtnVal (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID, FieldValue, MemoValue, FormID, PageID
			FROM Data_FieldValue
			WHERE FormID = ?
			AND VersionState = 2
			AND FieldID IN (4757,4758,10939,10940) AND PageID IN (61895)
			ORDER BY PageID, FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID
			FROM FormControl
			WHERE FormName = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Press Release

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID
			FROM FormInputControlMap
			WHERE FormID = ?
			ORDER BY FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID, FieldName
			FROM FormInputControl
			WHERE ID IN (4757,4758,10939,10940)
			ORDER BY ID ASC
		
rtnVal (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID, FieldValue, MemoValue, FormID, PageID
			FROM Data_FieldValue
			WHERE FormID = ?
			AND VersionState = 2
			AND FieldID IN (4757,4758,10939,10940) AND PageID IN (61897)
			ORDER BY PageID, FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID
			FROM FormControl
			WHERE FormName = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Press Release

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID
			FROM FormInputControlMap
			WHERE FormID = ?
			ORDER BY FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

formControlSelect (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT ID, FieldName
			FROM FormInputControl
			WHERE ID IN (4757,4758,10939,10940)
			ORDER BY ID ASC
		
rtnVal (Datasource=commonspot-site-dhs, Time=16ms, Records=4) in C:\inetpub\wwwroot\dhs\customcf\CommonSpotCustomElement.cfc @ 01:29:37.037
			SELECT FieldID, FieldValue, MemoValue, FormID, PageID
			FROM Data_FieldValue
			WHERE FormID = ?
			AND VersionState = 2
			AND FieldID IN (4757,4758,10939,10940) AND PageID IN (28953)
			ORDER BY PageID, FieldID ASC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4755

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:29:37.037
		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 @ 01:29:37.037
		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

Request.GetGhost (Datasource=commonspot-site-dhs, Time=15ms, Records=0) in C:\inetpub\wwwroot\commonspot\upfront-ghost-queries.cfm @ 01:29:37.037
	SELECT *
	  FROM Data_Ghost_Common
	 WHERE (PageID=1505 OR (PageID IN (1501,2,1) AND (VersionState = 2)))
	ORDER BY ControlID, PageID DESC
qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 01:29:37.037
		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) = 36

getForms (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\metadata\tags\form_control\load_core.cfm @ 01:29:37.037
		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 9410 ORDER BY d1.id, d2.id 
GetWDDXData (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:29:37.037
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=1505 AND (VersionState = 2)) OR ((PageID IN (1501,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9408
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 36

GetWDDXData (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:29:37.037
		SELECT *
		  FROM Param_WDDX
		 WHERE PageID=0
			AND ControlID=0
			AND ItemID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 36

GetWDDXData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 01:29:37.037
	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=1505 AND (VersionState = 2)) OR ((PageID IN (1501,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9408
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 36

GetChildren (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\page.cfm @ 01:29:37.037
			SELECT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
				AND PageID IN (SELECT ID
									  FROM SitePages
									 WHERE PageType=?)

			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4727
Parameter #2(CF_SQL_INTEGER) = 1

pageIndexQuery (Datasource=commonspot-site-dhs, Time=16ms, Records=134) in C:\inetpub\wwwroot\commonspot\components\query-engine\page-index.cfc @ 01:29:37.037
			SELECT SitePages.*,GeneralCategories.Category 
				,UploadedDocs.PublicFileName
		
			  FROM GeneralCategories,SitePages 
			LEFT OUTER JOIN UploadedDocs ON UploadedDocs.PageID = SitePages.ID AND UploadedDocs.VersionState = 2
		
			 WHERE
				
		(SitePages.ExpDate >= ?
			OR	(SitePages.ExpDate is NULL or SitePages.ExpDate = ''))
	AND GeneralCategories.ID = SitePages.CategoryID AND GeneralCategories.CategoryTypeID = 1 AND SitePages.AudienceID = ? AND SitePages.SubSiteID <> ? AND SitePages.PageSetID = ? AND SitePages.ApprovalStatus = ? AND 
		( (SitePages.PageType IN (?,?,?,?)) 
		)
		AND 
		( (SitePages.IsPublic IN (?,?,?,?,?,?,?,?)) 
		)
	AND 
			(
			SitePages.ID IN 
		(
			SELECT DISTINCT PageID
			  FROM TemplateInheritance
			 WHERE (InheritedFromPageID = ?) 
		)
	
			)
			
				ORDER BY SitePages.PublicReleaseDate desc,SitePages.title desc,SitePages.ID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2024-07-03 01:29:37
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 0
Parameter #6(CF_SQL_INTEGER) = 0
Parameter #7(CF_SQL_INTEGER) = 14
Parameter #8(CF_SQL_INTEGER) = 6
Parameter #9(CF_SQL_INTEGER) = 8
Parameter #10(CF_SQL_INTEGER) = 11
Parameter #11(CF_SQL_INTEGER) = 1
Parameter #12(CF_SQL_INTEGER) = 13
Parameter #13(CF_SQL_INTEGER) = 3
Parameter #14(CF_SQL_INTEGER) = 15
Parameter #15(CF_SQL_INTEGER) = 5
Parameter #16(CF_SQL_INTEGER) = 7
Parameter #17(CF_SQL_INTEGER) = 9
Parameter #18(CF_SQL_INTEGER) = 4727

GetOwners (Datasource=commonspot-users, Time=0ms, Records=5) in C:\inetpub\wwwroot\commonspot\controls\pageindex\query-and-params.cfm @ 01:29:37.037
		SELECT DISTINCT ContactID, FullName2 AS fullname
		  FROM UserFullNames
		 WHERE (ContactID IN (1000006,1000008,1000034,1000041,1000042))
		 
		 	UNION
		
		SELECT DISTINCT ID as ContactID, GroupName AS fullname
		  FROM idgroup
		 WHERE (ID IN (1000006,1000008,1000034,1000041,1000042)) 
GetDocType (Datasource=commonspot-site-dhs, Time=0ms, Records=79) in C:\inetpub\wwwroot\commonspot\controls\pageindex\query-and-params.cfm @ 01:29:37.037
		SELECT *
		  FROM Formats
	
getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 01:29:37.037
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 36
Parameter #2(cf_sql_integer) = 9410

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:29:37.037
		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 @ 01:29:37.037
		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

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:29:37.037
		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 @ 01:29:37.037
		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


Trace Points

information type [01:29:37.067 C:\inetpub\wwwroot\dhs\customcf\pagination.cfc @ line: 164] [828 ms (1st trace)] - [Pagination] Initialized Pagination CFC
information type [01:29:37.067 C:\inetpub\wwwroot\dhs\customcf\pagination.cfc @ line: 554] [828 ms (0 ms)] - [Pagination] Call to render HTML
information type [01:29:37.083 C:\inetpub\wwwroot\dhs\customcf\pagination.cfc @ line: 641] [844 ms (16 ms)] - [Pagination] Rendering fresh HTML
information type [01:29:37.083 C:\inetpub\wwwroot\dhs\customcf\pagination.cfc @ line: 684] [844 ms (0 ms)] - [Pagination] Rendering fresh HTML
information type [01:29:37.114 C:\inetpub\wwwroot\dhs\customcf\pagination.cfc @ line: 554] [875 ms (31 ms)] - [Pagination] Call to render HTML


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 (32)
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)
customerinfo=Complex type
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 (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
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\Who-We-Are\News-Room\Press-Releases.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=CSRFTOKEN=9CBB61615F2FE6CC60F290D58E5D90D63AE4ECB1; JSESSIONID=B717CACF827007842B0FDEF6165EF90A.cfusion
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/Who-We-Are/News-Room/Press-Releases.cfm
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\Who-We-Are\News-Room\Press-Releases.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.0.149
REMOTE_HOST=10.0.0.149
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Who-We-Are/News-Room/Press-Releases.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=9CBB61615F2FE6CC60F290D58E5D90D63AE4ECB1
JSESSIONID=B717CACF827007842B0FDEF6165EF90A.cfusion
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=27
cachestatus=Complex type
cfflushcount=0
cftracelastms=1719970177114
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=3286930944
cs_runningdashboardcmdcode=0
csrftoken=9CBB61615F2FE6CC60F290D58E5D90D63AE4ECB1
ctrl_data=Struct (91)
customcfupfront=
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 (2)
elementsrun=2
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-03 01:29:36
getghost=Query (0)
gvpageid=1505
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719970176239
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
prevtracetick=875
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-03 01:29:36.239
req_sequenceid=57009
req_startticks=1719970176239
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_B717CACF827007842B0FDEF6165EF90A.cfusion
sessionstring=1_B717CACF827007842B0FDEF6165EF90A.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
structdoctypes=Struct (158)
structowners=Struct (5)
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=18
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
thecontrolid=9408
timestamp={ts '2024-07-03 01:29:36'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
vcontrolid=9408
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=9CBB61615F2FE6CC60F290D58E5D90D63AE4ECB1
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=1505
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
indgrpid=
indid=
language=Struct (216)
langval=en
lastupdate=Struct (2)
lastuserupdate=1719970174630
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=B717CACF827007842B0FDEF6165EF90A.cfusion
sessionstring=1_B717CACF827007842B0FDEF6165EF90A.cfusion
subjectid=
tagindlist=
tagval=0
urltoken=CFID=2273055&CFTOKEN=6fa4056bec6bb897-9E1CB6C7-9573-B548-E1A80DC1A588F4A1&jsessionid=B717CACF827007842B0FDEF6165EF90A.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
page=1
Debug Rendering Time: 47 ms