500 Error
Column [NbrOfNativeAmerChildWIC] not found in query, Columns are [REPORTINGYEAR, SCCOUNTYCD, NBROFCHILDRENRECVWICBELOW100PERCENTFPLAGE0TO4, NBROFCHILDRENRECVWICBELOW150PERCENTFPLAGE0TO4, NBROFCHILDRENRECVWICBELOW185PERCENTFPLAGE0TO4, NBROFAFRICANAMERCHILDWIC, NBROFCAUCASIANCHILDRENWIC, NBROFMULTIRACIALCHILDWIC, NBROFHISPANICLATINOCHILDWIC, NBROFNONHISPANICNONLATINCHILDWIC, NBROFUNKNOWNRACECHILDRENWIC, NBROFOTHERRACECHILDRENWIC, NBROFCHILDRENMULTIETHNICWIC, NBROFCHILDREN0TO8USINGHEALTHYCONNECTIONS, NBROFCHILDREN0TO8RECEIVINGSNAP, NBROFCHILDREN0TO8RECEIVINGTANF, NBROFCHILDREN0TO5RECEIVINGSPECIALHEALTHCARENEEDS, NBROFCHILDRENAGES0TO5YOSERVEDBYTHELOCALFIRSTSTEPSPARTNERSHIP, SCCOUNTYNM]
SQL: SELECT
m.[ReportingYear]
,m.[SCCountyCd]
,m.[NbrOfChildrenRecvWICBelow100PercentFPLAge0To4]
,m.[NbrOfChildrenRecvWICBelow150PercentFPLAge0To4]
,m.[NbrOfChildrenRecvWICBelow185PercentFPLAge0To4]
,m.[NbrOfAfricanAmerChildWIC]
,m.[NbrOfCaucasianChildrenWIC]
,m.[NbrOfMultiRacialChildWIC]
,m.[NbrOfHispanicLatinoChildWIC]
,m.[NbrOfNonHispanicNonLatinChildWIC]
,m.[NbrOfUnknownRaceChildrenWIC]
,m.[NbrOfOtherRaceChildrenWIC]
,m.[NbrOfChildrenMultiEthnicWIC]
,m.[NbrOfChildren0To8UsingHealthyConnections]
,m.[NbrOfChildren0To8ReceivingSNAP]
,m.[NbrOfChildren0To8ReceivingTANF]
,m.[NbrOfChildren0To5ReceivingSpecialHealthCareNeeds]
,m.[NbrOfChildrenAges0to5YOServedByTheLocalFirstStepsPartnership]
,c.SCCountyNm
FROM SupportServices m
INNER JOIN CountyMGMT c
ON m.SCCountyCD = c.SCCountyCd
WHERE m.ReportingYear = 2023
AND (
m.SCCountyCd = '00'
)
ORDER BY SCCountyCd
Code: 0
Type: 0
Column: 0
ID: ??
Line: 985
Raw Trace: sites.scprofile.includes.scprofile.print_cfm$cf.call_000026(/muraWRM/sites/SCProfile/includes/scprofile/print.cfm:985)
Template: D:\www\sites\SCProfile\includes\scprofile\print.cfm
Type: cfml
Column: 0
ID: ??
Line: 946
Raw Trace: sites.scprofile.includes.scprofile.print_cfm$cf.call(/muraWRM/sites/SCProfile/includes/scprofile/print.cfm:946)
Template: D:\www\sites\SCProfile\includes\scprofile\print.cfm
Type: cfml
Column: 0
ID: ??
Line: 2796
Raw Trace: content.contentrenderer_cfc$cf.udfCall9(/mura/content/contentRenderer.cfc:2796)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 2735
Raw Trace: content.contentrenderer_cfc$cf.udfCall9(/mura/content/contentRenderer.cfc:2735)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 88
Raw Trace: content.contentrendererutility_cfc$cf.udfCall1(/mura/content/contentRendererUtility.cfc:88)
Template: D:\www\core\mura\content\contentRendererUtility.cfc
Type: cfml
Column: 0
ID: ??
Line: 3090
Raw Trace: content.contentrenderer_cfc$cf.udfCallc(/mura/content/contentRenderer.cfc:3090)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 262
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:262)
Template: D:\www\core\mura\cfobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 135
Raw Trace: masascope_cfc$cf.udfCall1(/mura/MasaScope.cfc:135)
Template: D:\www\core\mura\MasaScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 93
Raw Trace: sites.scprofile.includes.themes.scprofile.content_types.page.index_cfm$cf.call(/muraWRM/sites/SCProfile/includes/themes/SCProfile/content_types/page/index.cfm:93)
Template: D:\www\sites\SCProfile\includes\themes\SCProfile\content_types\page\index.cfm
Type: cfml
Column: 0
ID: ??
Line: 1856
Raw Trace: content.contentrenderer_cfc$cf.udfCall4_000066(/mura/content/contentRenderer.cfc:1856)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 1759
Raw Trace: content.contentrenderer_cfc$cf.udfCall4(/mura/content/contentRenderer.cfc:1759)
Template: D:\www\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 262
Raw Trace: cfobject_cfc$cf.udfCall3(/mura/cfobject.cfc:262)
Template: D:\www\core\mura\cfobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 135
Raw Trace: masascope_cfc$cf.udfCall1(/mura/MasaScope.cfc:135)
Template: D:\www\core\mura\MasaScope.cfc
Type: cfml
Column: 0
ID: ??
Line: 14
Raw Trace: sites.scprofile.includes.themes.scprofile.templates.one_column_cfm$cf.call(/muraWRM/sites/SCProfile/includes/themes/SCProfile/templates/one_column.cfm:14)
Template: D:\www\sites\SCProfile\includes\themes\SCProfile\templates\one_column.cfm
Type: cfml
Column: 0
ID: ??
Line: 130
Raw Trace: translator.standardhtmltranslator_cfc$cf.udfCall(/mura/Translator/standardHTMLTranslator.cfc:130)
Template: D:\www\core\mura\Translator\standardHTMLTranslator.cfc
Type: cfml
Column: 0
ID: ??
Line: 169
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:169)
Template: D:\www\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 119
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall1(/mura/Handler/standardEventsHandler.cfc:119)
Template: D:\www\core\mura\Handler\standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1415
Raw Trace: utility_cfc$cf.udfCall7(/mura/utility.cfc:1415)
Template: D:\www\core\mura\utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 119
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:119)
Template: D:\www\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 454
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall3(/mura/Handler/standardEventsHandler.cfc:454)
Template: D:\www\core\mura\Handler\standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1415
Raw Trace: utility_cfc$cf.udfCall7(/mura/utility.cfc:1415)
Template: D:\www\core\mura\utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 119
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:119)
Template: D:\www\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 915
Raw Trace: content.contentserver_cfc$cf.udfCall2_000080(/mura/content/contentServer.cfc:915)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 907
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:907)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 294
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:294)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 380
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:380)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 786
Raw Trace: content.contentserver_cfc$cf.udfCall2_000060(/mura/content/contentServer.cfc:786)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 782
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:782)
Template: D:\www\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 75
Raw Trace: index_cfm$cf.call(/index.cfm:75)
Template: D:\www\index.cfm
Type: cfml