CUSTOMER REVIEW
Let us know how we did!

We strive to provide you with the best products and services in the industry. We would love to hear some of your feedback so that we can try to continually improve our business and find new ways to serve you better.

* = Required
Name *
Email *
Phone (Optional)
Product or Service that you purchased? *
Was our staff and service representatives knowledgeable? *
Did our staff and service representatives act in your best interest? *
Did our team respond to your inquiries in a timely manner? *
Was our store front clean, organized and inviting? *
How would you rate the quality of your product and/or service? *
How do you rate the overall value of the product/service at the cost that you paid for it? *
How would you rate our selection of our products and services? *
Based on your experience with us, how likely are you to buy from us again? *
Would you recommend us to a friend or family member? *
On a scale of 1 to 10 (10 being best), what was the overall satisfaction of your experience? *
Please share with us a few things could do better.
Please share a testimonial or any additional comments or experiences, please enter them below.
Will you allow us to use any of this feedback as a testimonial on our website? *
Yes    No


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]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/footer1.cfm: line 22
Called from C:/web/diplomatpools.com/forms/index.cfm: line 273
Called from C:/web/diplomatpools.com/forms/index.cfm: line 269
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/footer1.cfm: line 22
Called from C:/web/diplomatpools.com/forms/index.cfm: line 273
Called from C:/web/diplomatpools.com/forms/index.cfm: line 269
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.73
Referrer  
Date/Time   01-Jul-25 07:54 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 cffooter12ecfm44347256.runPage(C:/web/diplomatpools.com/config/footer1.cfm:22) at cfindex2ecfm793152225._factor8(C:/web/diplomatpools.com/forms/index.cfm:273) at cfindex2ecfm793152225.runPage(C:/web/diplomatpools.com/forms/index.cfm:269) 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 cffooter12ecfm44347256.runPage(C:/web/diplomatpools.com/config/footer1.cfm:22) at cfindex2ecfm793152225._factor8(C:/web/diplomatpools.com/forms/index.cfm:273) at cfindex2ecfm793152225.runPage(C:/web/diplomatpools.com/forms/index.cfm:269)

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 cffooter12ecfm44347256.runPage(C:\web\diplomatpools.com\config\footer1.cfm:22)
	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 cfindex2ecfm793152225._factor8(C:\web\diplomatpools.com\forms\index.cfm:273)
	at cfindex2ecfm793152225.runPage(C:\web\diplomatpools.com\forms\index.cfm:269)
	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)