Energyshop.com - Energy for your home
Electricity Natural Gas Contact Us Site Map
Energyshop
Residential Services
 
Natural Gas, Electricity for Business Customers

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

Error Executing Database Query.


Query Of Queries syntax error.
Encountered "nHistoricalID = ). Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
 
The error occurred in C:/inetpub/wwwroot/es/homes/gas/newResidentialChart.cfm: line 73
Called from C:/inetpub/wwwroot/es/homes/gas/historical_savings-content.cfm: line 1
Called from C:/inetpub/wwwroot/es/homes/gas/historical_savings.cfm: line 57
Called from C:/inetpub/wwwroot/es/homes/gas/newResidentialChart.cfm: line 73
Called from C:/inetpub/wwwroot/es/homes/gas/historical_savings-content.cfm: line 1
Called from C:/inetpub/wwwroot/es/homes/gas/historical_savings.cfm: line 57
71 : SELECT *
72 : FROM   qrySavings
73 : WHERE  (nHistoricalID = #qrySavings.nHistoricalID[(Round(qrySavings.RecordCount * 0.6667))]#)
74 : </cfquery>
75 : <cfif qryUtility.sLdcName GT "">

SQL    SELECT * FROM qrySavings WHERE (nHistoricalID = )
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.80.60.248
Referrer  
Date/Time   16-Feb-19 11:39 PM
Stack Trace
at cfnewResidentialChart2ecfm669801366.runPage(C:/inetpub/wwwroot/es/homes/gas/newResidentialChart.cfm:73) at cfhistorical_savings2dcontent2ecfm918542020.runPage(C:/inetpub/wwwroot/es/homes/gas/historical_savings-content.cfm:1) at cfhistorical_savings2ecfm769136272.runPage(C:/inetpub/wwwroot/es/homes/gas/historical_savings.cfm:57) at cfnewResidentialChart2ecfm669801366.runPage(C:/inetpub/wwwroot/es/homes/gas/newResidentialChart.cfm:73) at cfhistorical_savings2dcontent2ecfm918542020.runPage(C:/inetpub/wwwroot/es/homes/gas/historical_savings-content.cfm:1) at cfhistorical_savings2ecfm769136272.runPage(C:/inetpub/wwwroot/es/homes/gas/historical_savings.cfm:57)

java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br>
Encountered "nHistoricalID = ).
Incorrect conditional expression, 
Expected one of [like|null|between|in|comparison] condition, 

	at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590)
	at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547)
	at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1495)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfnewResidentialChart2ecfm669801366.runPage(C:\inetpub\wwwroot\es\homes\gas\newResidentialChart.cfm:73)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfhistorical_savings2dcontent2ecfm918542020.runPage(C:\inetpub\wwwroot\es\homes\gas\historical_savings-content.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfhistorical_savings2ecfm769136272.runPage(C:\inetpub\wwwroot\es\homes\gas\historical_savings.cfm:57)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	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:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)