ASK THE POOL AND SPA EXPERTS
Have a question? We are ready to help!

Tell us a little bit about what you are looking for so we can better assist you!

* = Required
Name *
Email *
Phone (Optional)
Concern or Comment? *


Enter above value to submit form used to stop form spam

I approve Diplomat Pools & Spas to send me correspondence through email regarding their promotions, products & services


 



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.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
 
The error occurred in C:/home/diplomatpools.com/secure_html/etrack/VE/VEEND.cfm: line 141
Called from C:/home/diplomatpools.com/secure_html/etrack/VE/act_runVETask.cfm: line 43
Called from C:/home/diplomatpools.com/config/triggers.cfm: line 815
Called from C:/home/diplomatpools.com/config/triggers.cfm: line 814
Called from C:/home/diplomatpools.com/config/triggers.cfm: line 1
Called from C:/home/diplomatpools.com/config/footer1.cfm: line 22
Called from C:/home/diplomatpools.com/forms/index.cfm: line 254
Called from C:/home/diplomatpools.com/secure_html/etrack/VE/VEEND.cfm: line 141
Called from C:/home/diplomatpools.com/secure_html/etrack/VE/act_runVETask.cfm: line 43
Called from C:/home/diplomatpools.com/config/triggers.cfm: line 815
Called from C:/home/diplomatpools.com/config/triggers.cfm: line 814
Called from C:/home/diplomatpools.com/config/triggers.cfm: line 1
Called from C:/home/diplomatpools.com/config/footer1.cfm: line 22
Called from C:/home/diplomatpools.com/forms/index.cfm: line 254
139 : 					expiry = '3000-01-01',
140 : 					active = 0
141 : 			where id = #VEtasks.couponID#
142 : 		</cfquery>
143 : 	</cfif>

SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   diplomat
VENDORERRORCODE   102
SQL   update CM_coupons set publishfrom = '3000-01-01', publishto = '3000-01-01', expiry = '3000-01-01', active = 0 where id =
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   44.200.194.255
Referrer  
Date/Time   24-Jul-24 10:32 PM
Stack Trace
at cfVEEND2ecfm1302771101.runPage(C:/home/diplomatpools.com/secure_html/etrack/VE/VEEND.cfm:141) at cfact_runVETask2ecfm1164495548.runPage(C:/home/diplomatpools.com/secure_html/etrack/VE/act_runVETask.cfm:43) at cftriggers2ecfm558354427._factor36(C:/home/diplomatpools.com/config/triggers.cfm:815) at cftriggers2ecfm558354427._factor40(C:/home/diplomatpools.com/config/triggers.cfm:814) at cftriggers2ecfm558354427.runPage(C:/home/diplomatpools.com/config/triggers.cfm:1) at cffooter12ecfm222737082.runPage(C:/home/diplomatpools.com/config/footer1.cfm:22) at cfindex2ecfm414045428.runPage(C:/home/diplomatpools.com/forms/index.cfm:254) at cfVEEND2ecfm1302771101.runPage(C:/home/diplomatpools.com/secure_html/etrack/VE/VEEND.cfm:141) at cfact_runVETask2ecfm1164495548.runPage(C:/home/diplomatpools.com/secure_html/etrack/VE/act_runVETask.cfm:43) at cftriggers2ecfm558354427._factor36(C:/home/diplomatpools.com/config/triggers.cfm:815) at cftriggers2ecfm558354427._factor40(C:/home/diplomatpools.com/config/triggers.cfm:814) at cftriggers2ecfm558354427.runPage(C:/home/diplomatpools.com/config/triggers.cfm:1) at cffooter12ecfm222737082.runPage(C:/home/diplomatpools.com/config/footer1.cfm:22) at cfindex2ecfm414045428.runPage(C:/home/diplomatpools.com/forms/index.cfm:254)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1103)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
	at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
	at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
	at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1892)
	at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
	at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.go.execute(BaseStatement.java:4425)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1623)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1365)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1295)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfVEEND2ecfm1302771101.runPage(C:\home\diplomatpools.com\secure_html\etrack\VE\VEEND.cfm:141)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfact_runVETask2ecfm1164495548.runPage(C:\home\diplomatpools.com\secure_html\etrack\VE\act_runVETask.cfm:43)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cftriggers2ecfm558354427._factor36(C:\home\diplomatpools.com\config\triggers.cfm:815)
	at cftriggers2ecfm558354427._factor40(C:\home\diplomatpools.com\config\triggers.cfm:814)
	at cftriggers2ecfm558354427.runPage(C:\home\diplomatpools.com\config\triggers.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cffooter12ecfm222737082.runPage(C:\home\diplomatpools.com\config\footer1.cfm:22)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfindex2ecfm414045428.runPage(C:\home\diplomatpools.com\forms\index.cfm:254)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	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:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:373)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)