Error Occurred While Processing Request
Error Occurred While Processing Request

Error Executing Database Query.

Invalid data for CFSQLTYPE CF_SQL_INTEGER.
 
The error occurred in D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc: line 537
Called from D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc: line 128
Called from D:\Inetpub\wwwroot\gemeinde_aarau\xml_1\internet\de\application\d88\d134\f4912.cfm: line 26
Called from D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc: line 537
Called from D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc: line 128
Called from D:\Inetpub\wwwroot\gemeinde_aarau\xml_1\internet\de\application\d88\d134\f4912.cfm: line 26
535 : 								<cfelse>
536 : 								 PID = <cfqueryparam cfsqltype="cf_sql_integer" value="#qryGet.ID#">
537 : 								</cfif>
538 : 						</cfquery>
539 : 						<cfif qryGetChildren.RecordCount>

SQL    SELECT ID,strShortCut FROM this.qryGetAllChildren WHERE ID = (param 1)
Please try the following:

Browser   ColdFusion
Remote Address   192.168.56.27
Referrer  
Date/Time   30-Jul-16 06:02 PM
Stack Trace
at cfwai_nav2ecfc1711411133$funcCREATELISTDB.runFunction(D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc:537) at cfwai_nav2ecfc1711411133$funcCREATE.runFunction(D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc:128) at cff49122ecfm1008858367.runPage(D:\Inetpub\wwwroot\gemeinde_aarau\xml_1\internet\de\application\d88\d134\f4912.cfm:26) at cfwai_nav2ecfc1711411133$funcCREATELISTDB.runFunction(D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc:537) at cfwai_nav2ecfc1711411133$funcCREATE.runFunction(D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc:128) at cff49122ecfm1008858367.runPage(D:\Inetpub\wwwroot\gemeinde_aarau\xml_1\internet\de\application\d88\d134\f4912.cfm:26)

java.sql.SQLException: Invalid data  for CFSQLTYPE CF_SQL_INTEGER.
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:259)
	at coldfusion.sql.Parameter.getMappingValues(Parameter.java:35)
	at coldfusion.sql.InParameter.setStatement(InParameter.java:29)
	at coldfusion.sql.ParameterList.setStatement(ParameterList.java:104)
	at coldfusion.sql.Executive.executeQuery(Executive.java:978)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:240)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
	at cfwai_nav2ecfc1711411133$funcCREATELISTDB.runFunction(D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc:537)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:44)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:250)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:165)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1773)
	at cfwai_nav2ecfc1711411133$funcCREATE.runFunction(D:\Inetpub\wwwroot\gemeinde_aarau\cfc\global\online\wai_nav.cfc:128)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:338)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:286)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:250)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:53)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:203)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:359)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:196)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:139)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1587)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:327)
	at cff49122ecfm1008858367.runPage(D:\Inetpub\wwwroot\gemeinde_aarau\xml_1\internet\de\application\d88\d134\f4912.cfm:26)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:105)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doHttpServletRequest(FusionReactorCoreFilter.java:503)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:337)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)