Site Map

• Gas prices

• Electricity prices

• Gas FAQ

• Electricity FAQ

• Price forecasts

• Electricity projections

• Toolbox

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:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

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)