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:\Mura\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:\Mura\sites\SCProfile\includes\scprofile\print.cfm
Type: cfml
Column: 0
ID: ??
Line: 2762
Raw Trace: content.contentrenderer_cfc$cf.udfCalla(/mura/content/contentRenderer.cfc:2762)
Template: D:\Mura\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 2713
Raw Trace: content.contentrenderer_cfc$cf.udfCall9(/mura/content/contentRenderer.cfc:2713)
Template: D:\Mura\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:\Mura\core\mura\content\contentRendererUtility.cfc
Type: cfml
Column: 0
ID: ??
Line: 3097
Raw Trace: content.contentrenderer_cfc$cf.udfCallc(/mura/content/contentRenderer.cfc:3097)
Template: D:\Mura\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 189
Raw Trace: baseobject_cfc$cf.udfCall3(/mura/baseobject.cfc:189)
Template: D:\Mura\core\mura\baseobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 63
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:63)
Template: D:\Mura\core\mura\MuraScope.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:\Mura\sites\SCProfile\includes\themes\SCProfile\content_types\page\index.cfm
Type: cfml
Column: 0
ID: ??
Line: 1793
Raw Trace: content.contentrenderer_cfc$cf.udfCall5(/mura/content/contentRenderer.cfc:1793)
Template: D:\Mura\core\mura\content\contentRenderer.cfc
Type: cfml
Column: 0
ID: ??
Line: 189
Raw Trace: baseobject_cfc$cf.udfCall3(/mura/baseobject.cfc:189)
Template: D:\Mura\core\mura\baseobject.cfc
Type: cfml
Column: 0
ID: ??
Line: 63
Raw Trace: murascope_cfc$cf.udfCall1(/mura/MuraScope.cfc:63)
Template: D:\Mura\core\mura\MuraScope.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:\Mura\sites\SCProfile\includes\themes\SCProfile\templates\one_column.cfm
Type: cfml
Column: 0
ID: ??
Line: 63
Raw Trace: translator.standardhtmltranslator_cfc$cf.udfCall(/mura/Translator/standardHTMLTranslator.cfc:63)
Template: D:\Mura\core\mura\Translator\standardHTMLTranslator.cfc
Type: cfml
Column: 0
ID: ??
Line: 95
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:95)
Template: D:\Mura\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 36
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall1(/mura/Handler/standardEventsHandler.cfc:36)
Template: D:\Mura\core\mura\Handler\standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1533
Raw Trace: utility_cfc$cf.udfCall8(/mura/utility.cfc:1533)
Template: D:\Mura\core\mura\utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 45
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:45)
Template: D:\Mura\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 316
Raw Trace: handler.standardeventshandler_cfc$cf.udfCall3(/mura/Handler/standardEventsHandler.cfc:316)
Template: D:\Mura\core\mura\Handler\standardEventsHandler.cfc
Type: cfml
Column: 0
ID: ??
Line: 1533
Raw Trace: utility_cfc$cf.udfCall8(/mura/utility.cfc:1533)
Template: D:\Mura\core\mura\utility.cfc
Type: cfml
Column: 0
ID: ??
Line: 45
Raw Trace: plugin.pluginstandardeventwrapper_cfc$cf.udfCall(/mura/plugin/pluginStandardEventWrapper.cfc:45)
Template: D:\Mura\core\mura\plugin\pluginStandardEventWrapper.cfc
Type: cfml
Column: 0
ID: ??
Line: 973
Raw Trace: content.contentserver_cfc$cf.udfCall2_000095(/mura/content/contentServer.cfc:973)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 965
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:965)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 245
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:245)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 335
Raw Trace: content.contentserver_cfc$cf.udfCall1(/mura/content/contentServer.cfc:335)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 790
Raw Trace: content.contentserver_cfc$cf.udfCall2_000067(/mura/content/contentServer.cfc:790)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 786
Raw Trace: content.contentserver_cfc$cf.udfCall2(/mura/content/contentServer.cfc:786)
Template: D:\Mura\core\mura\content\contentServer.cfc
Type: cfml
Column: 0
ID: ??
Line: 1
Raw Trace: index_cfm$cf.call(/index.cfm:1)
Template: D:\Mura\index.cfm
Type: cfml