MY ACCOUNT PAY INVOICE


Client Satisfaction Survey
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 Blue Horizon 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]Cannot create a row of size 8062 which is greater than the allowable maximum row size of 8060.
 
The error occurred in C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 915
Called from C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 1
Called from C:/home/bluehorizonpoolsandspas.com/config/footer2.cfm: line 20
Called from C:/home/bluehorizonpoolsandspas.com/forms/index.cfm: line 254
Called from C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 915
Called from C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm: line 1
Called from C:/home/bluehorizonpoolsandspas.com/config/footer2.cfm: line 20
Called from C:/home/bluehorizonpoolsandspas.com/forms/index.cfm: line 254
 
913 : 	update EM_SR_Bookings
914 : 	set ccn = 'xxxx xxxx xxxx xxxx'
915 : 	where (DATEDIFF(day, bookingdate, <CFQUERYPARAM Value="#CreateODBCDateTime(now())#" cfsqltype="CF_SQL_TIMESTAMP">) > 5)
916 : </cfquery>
917 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#">
SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   BlueHorizonPoolsandSpas08
VENDORERRORCODE   511
SQL   update EM_SR_Bookings set ccn = 'xxxx xxxx xxxx xxxx' where (DATEDIFF(day, bookingdate, (param 1) ) > 5)
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.235.226.14
Referrer  
Date/Time   08-Sep-24 10:37 PM
Stack Trace
at cftriggers2ecfm1613175086._factor41(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:915) at cftriggers2ecfm1613175086.runPage(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:1) at cffooter22ecfm119122724.runPage(C:/home/bluehorizonpoolsandspas.com/config/footer2.cfm:20) at cfindex2ecfm209127681.runPage(C:/home/bluehorizonpoolsandspas.com/forms/index.cfm:254) at cftriggers2ecfm1613175086._factor41(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:915) at cftriggers2ecfm1613175086.runPage(C:/home/bluehorizonpoolsandspas.com/config/triggers.cfm:1) at cffooter22ecfm119122724.runPage(C:/home/bluehorizonpoolsandspas.com/config/footer2.cfm:20) at cfindex2ecfm209127681.runPage(C:/home/bluehorizonpoolsandspas.com/forms/index.cfm:254) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot create a row of size 8062 which is greater than the allowable maximum row size of 8060.
	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.r.a(TDSRPCRequest.java:1063)
	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.fe.B(BasePreparedStatement.java:530)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java:2656)
	at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java:525)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1639)
	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 cftriggers2ecfm1613175086._factor41(C:\home\bluehorizonpoolsandspas.com\config\triggers.cfm:915)
	at cftriggers2ecfm1613175086.runPage(C:\home\bluehorizonpoolsandspas.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 cffooter22ecfm119122724.runPage(C:\home\bluehorizonpoolsandspas.com\config\footer2.cfm:20)
	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 cfindex2ecfm209127681.runPage(C:\home\bluehorizonpoolsandspas.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)