search icon search iconSearch A-Z Index Members IconMember Portal Members IconOnline Giving
Close
Members Icon

Visitors

Welcome to the First Presbyterian Church portal. Please choose an option below to see our events, small groups or to give online.

Close

First Thoughts Blog

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.

 
The error occurred in D:/inetpub/wwwroot/content_FirstPres/content_Blog.cfm: line 157
Called from D:/inetpub/wwwroot/content_FirstPres/content_Blog.cfm: line 148
Called from D:/inetpub/wwwroot/content_FirstPres/content_Blog.cfm: line 1
Called from D:/inetpub/wwwroot/content_FirstPres/content_Tools.cfm: line 92
Called from D:/inetpub/wwwroot/content_FirstPres/content.cfm: line 151
Called from D:/inetpub/wwwroot/content_FirstPres/content.cfm: line 1
155 :             WHERE tbl_BlogAuthor.AuthorID = <cfqueryparam value="#url.authorID#" cfsqltype="CF_SQL_INTEGER">
156 :             AND dbo.tbl_BlogEntry.AuthorID = tbl_BlogAuthor.AuthorID
157 :             AND entPublishDate <= #createODBCdatetime(now())#
158 :             AND entHide = 0
159 :             ORDER BY entPublishDate DESC

Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   44.211.31.134
Referrer  
Date/Time   18-Jul-24 02:56 PM
Stack Trace
at cfcontent_Blog2ecfm778232684._factor8(D:/inetpub/wwwroot/content_FirstPres/content_Blog.cfm:157) at cfcontent_Blog2ecfm778232684._factor11(D:/inetpub/wwwroot/content_FirstPres/content_Blog.cfm:148) at cfcontent_Blog2ecfm778232684.runPage(D:/inetpub/wwwroot/content_FirstPres/content_Blog.cfm:1) at cfcontent_Tools2ecfm285986018.runPage(D:/inetpub/wwwroot/content_FirstPres/content_Tools.cfm:92) at cfcontent2ecfm1962950841._factor5(D:/inetpub/wwwroot/content_FirstPres/content.cfm:151) at cfcontent2ecfm1962950841.runPage(D:/inetpub/wwwroot/content_FirstPres/content.cfm:1)

coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:112)
	at coldfusion.sql.Parameter.getMappingValues(Parameter.java:62)
	at coldfusion.sql.InParameter.setStatement(InParameter.java:72)
	at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1466)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfcontent_Blog2ecfm778232684._factor8(D:\inetpub\wwwroot\content_FirstPres\content_Blog.cfm:157)
	at cfcontent_Blog2ecfm778232684._factor11(D:\inetpub\wwwroot\content_FirstPres\content_Blog.cfm:148)
	at cfcontent_Blog2ecfm778232684.runPage(D:\inetpub\wwwroot\content_FirstPres\content_Blog.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfcontent_Tools2ecfm285986018.runPage(D:\inetpub\wwwroot\content_FirstPres\content_Tools.cfm:92)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:296)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfcontent2ecfm1962950841._factor5(D:\inetpub\wwwroot\content_FirstPres\content.cfm:151)
	at cfcontent2ecfm1962950841.runPage(D:\inetpub\wwwroot\content_FirstPres\content.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:722)