MY ACCOUNT PAY INVOICE

WE MAKE POOL & HOT TUB OWNERSHIP EASY

POOLS LS-service-img1
HOT TUBS LS-service-img2
SHOP PRODUCTS LS-service-img3
BOOK SERVICE LS-service-img4

MORE PRODUCTS & SERVICES

POOL RENOVATIONS
LS-product-img1
POOL MAINTENANCE
LS-product-img2
PROMOTIONS & EVENTS
LS-product-img3
FINANCING
LS-product-img4

We make backyard memories. The staff at Diplomat Leisurescapes has over 50 plus years experience in pool building; We have been fulfilling people’s swimming pool and spa needs in the Greater Toronto Area and in Pickering, Ajax, Whitby, Oshawa, Brooklin and the rest of the Durham Region for over 50 plus years which has allowed us to be a premier Swimming Pool and Spa and Hot Tub retailer

Diplomat Leisurescapes carries swimming pool, spa and hot tub chemicals, equipment (Filters, pumps, vacuums and more) parts and accessories for all of your pool and hot tub needs. We also offer pool and hot tub water analysis. We have one of the largest inventory of replacement parts for most pools and hot tubs. Anything that we don't have in stock, we can usually get for you in just a few days.

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]String or binary data would be truncated.
 
The error occurred in C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 46
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 15
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 1
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 450
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 1
Called from C:/web/diplomatpools.com/config/footer3.cfm: line 20
Called from C:/web/diplomatpools.com/index.cfm: line 164
Called from C:/web/diplomatpools.com/index.cfm: line 160
Called from C:/web/diplomatpools.com/index.cfm: line 1
Called from |SQLServer|6.0.0.1282|: line 1055
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2032
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from |SQLServer|6.0.0.1282|: line 1055
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2032
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 46
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 15
Called from C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm: line 1
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 450
Called from C:/web/diplomatpools.com/config/triggers.cfm: line 1
Called from C:/web/diplomatpools.com/config/footer3.cfm: line 20
Called from C:/web/diplomatpools.com/index.cfm: line 164
Called from C:/web/diplomatpools.com/index.cfm: line 160
Called from C:/web/diplomatpools.com/index.cfm: line 1
 
44 : 					<cfif getmoreInfo.postal IS NOT "">,postal = '#getAllUnassignedLeads.postal#'</cfif> 
45 : 					<cfif getmoreInfo.province IS NOT "">,province = '#getAllUnassignedLeads.province#'</cfif>
46 : 				where email = '#getAllUnassignedLeads.email#'
47 : 			</cfquery>
48 : 		</cfif>
SQLSTATE   22001
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   diplomat
VENDORERRORCODE   8152
SQL   update LG_Contacts set email = 'mmjefery@gmail.com' ,name = 'BEST RECOVERY EXPERT FOR LOST CRYPTOCURRENCY ASSETS; HIRE CYBER CONSTABLE INTELLIGENCE' where email = 'mmjefery@gmail.com'
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   216.73.216.1
Referrer   https://www.diplomatpools.com/contest/index.cfm?id=1
Date/Time   30-Jun-25 07:37 PM
Stack Trace
at cfsq_autoAssign2ecfm222736250._factor11(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:46) at cfsq_autoAssign2ecfm222736250._factor14(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:15) at cfsq_autoAssign2ecfm222736250.runPage(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:1) at cftriggers2ecfm806448206._factor42(C:/web/diplomatpools.com/config/triggers.cfm:450) at cftriggers2ecfm806448206.runPage(C:/web/diplomatpools.com/config/triggers.cfm:1) at cffooter32ecfm46169210.runPage(C:/web/diplomatpools.com/config/footer3.cfm:20) at cfindex2ecfm946165875._factor6(C:/web/diplomatpools.com/index.cfm:164) at cfindex2ecfm946165875._factor9(C:/web/diplomatpools.com/index.cfm:160) at cfindex2ecfm946165875.runPage(C:/web/diplomatpools.com/index.cfm:1) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at cfsq_autoAssign2ecfm222736250._factor11(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:46) at cfsq_autoAssign2ecfm222736250._factor14(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:15) at cfsq_autoAssign2ecfm222736250.runPage(C:/web/diplomatpools.com/crm/gateway/sq_autoAssign.cfm:1) at cftriggers2ecfm806448206._factor42(C:/web/diplomatpools.com/config/triggers.cfm:450) at cftriggers2ecfm806448206.runPage(C:/web/diplomatpools.com/config/triggers.cfm:1) at cffooter32ecfm46169210.runPage(C:/web/diplomatpools.com/config/footer3.cfm:20) at cfindex2ecfm946165875._factor6(C:/web/diplomatpools.com/index.cfm:164) at cfindex2ecfm946165875._factor9(C:/web/diplomatpools.com/index.cfm:160) at cfindex2ecfm946165875.runPage(C:/web/diplomatpools.com/index.cfm:1) 

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1055)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2032)
	at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
	at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
	at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
	at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
	at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1649)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1391)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1321)
	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 cfsq_autoAssign2ecfm222736250._factor11(C:\web\diplomatpools.com\crm\gateway\sq_autoAssign.cfm:46)
	at cfsq_autoAssign2ecfm222736250._factor14(C:\web\diplomatpools.com\crm\gateway\sq_autoAssign.cfm:15)
	at cfsq_autoAssign2ecfm222736250.runPage(C:\web\diplomatpools.com\crm\gateway\sq_autoAssign.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:5083)
	at cftriggers2ecfm806448206._factor42(C:\web\diplomatpools.com\config\triggers.cfm:450)
	at cftriggers2ecfm806448206.runPage(C:\web\diplomatpools.com\config\triggers.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:5083)
	at cffooter32ecfm46169210.runPage(C:\web\diplomatpools.com\config\footer3.cfm:20)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:5083)
	at cfindex2ecfm946165875._factor6(C:\web\diplomatpools.com\index.cfm:164)
	at cfindex2ecfm946165875._factor9(C:\web\diplomatpools.com\index.cfm:160)
	at cfindex2ecfm946165875.runPage(C:\web\diplomatpools.com\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	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:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	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:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	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:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:833)