MY ACCOUNT PAY INVOICE

SHOP NOW

NEED HELP FINDING THE RIGHT WATER TREATMENT?

Tested and proven effective, our water treatment products are known for delivering reliable results and making water care less complex.
Use our wizard assistant tool to get you to the right products. 
Simply answer the questions as you go... and through the process of elimination, we will get you to the products you need.

AT ANY POINT YOU CAN ABORT THE PROCESS BY CLICKING ON ANY DISPLAYED PRODUCT PICTURE WHICH WILL TAKE YOU TO THAT PRODUCT IN OUR ONLINE CATALOG....... LETS GET STARTED!






In order to use water treatment effectively, you will need a rough estimate of how much water is in your pool.
Use our Pool Volume Calculator!
We are starting with 185 possible products.

Question 1
Are you looking for water treatment products for your Pool or Hot Tub?
 



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/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 174
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 20
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/config/triggers.cfm: line 838
Called from C:/home/huroniapools.com/config/triggers.cfm: line 1
Called from C:/home/huroniapools.com/config/footer1.cfm: line 22
Called from C:/home/huroniapools.com/vs/index.cfm: line 407
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 174
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 20
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm: line 1
Called from C:/home/huroniapools.com/config/triggers.cfm: line 838
Called from C:/home/huroniapools.com/config/triggers.cfm: line 1
Called from C:/home/huroniapools.com/config/footer1.cfm: line 22
Called from C:/home/huroniapools.com/vs/index.cfm: line 407
 
172 : 						#forceToCWL#,
173 : 						#fake#,
174 : 						#truck#
175 : 
176 : 					)
SQLSTATE   HY000
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   Huronia
VENDORERRORCODE   102
SQL   insert into POS_TransactionItems ( transID, customerACCID, product, qty, price, fullprice, sku, revenuesource, cat, sub, taxable, void, cost, tax1, tax2, tax3, fullTaxAmount, location, inventoryCommitted, TransactionStatus, regprice, itemnote, warranty, taken, forceToCWL, fake, truck ) values ( 10567, 15053, 'Pool and Spa Maintenance + travel', 1, 135.00, 135.0000, 'poolspamaint', 'service', 'pool service', 'Pool and Spa Maintenance', 1, 0, 0, 13, 0, 0, 17.5500, 1, 1, 2, 135.0000, '', 0, 1, , 0, 0 )
Resources:

Browser   claudebot
Remote Address   3.141.100.120
Referrer  
Date/Time   16-Apr-24 09:12 AM
Stack Trace
at cfact_repeatMaintenance2ecfm2016920000._factor8(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:174) at cfact_repeatMaintenance2ecfm2016920000._factor11(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:20) at cfact_repeatMaintenance2ecfm2016920000._factor12(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cfact_repeatMaintenance2ecfm2016920000.runPage(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cftriggers2ecfm1966389557._factor40(C:/home/huroniapools.com/config/triggers.cfm:838) at cftriggers2ecfm1966389557.runPage(C:/home/huroniapools.com/config/triggers.cfm:1) at cffooter12ecfm960507936.runPage(C:/home/huroniapools.com/config/footer1.cfm:22) at cfindex2ecfm1539308683.runPage(C:/home/huroniapools.com/vs/index.cfm:407) at cfact_repeatMaintenance2ecfm2016920000._factor8(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:174) at cfact_repeatMaintenance2ecfm2016920000._factor11(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:20) at cfact_repeatMaintenance2ecfm2016920000._factor12(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cfact_repeatMaintenance2ecfm2016920000.runPage(C:/home/huroniapools.com/secure_html/eMerchant/srvRequest/act_repeatMaintenance.cfm:1) at cftriggers2ecfm1966389557._factor40(C:/home/huroniapools.com/config/triggers.cfm:838) at cftriggers2ecfm1966389557.runPage(C:/home/huroniapools.com/config/triggers.cfm:1) at cffooter12ecfm960507936.runPage(C:/home/huroniapools.com/config/footer1.cfm:22) at cfindex2ecfm1539308683.runPage(C:/home/huroniapools.com/vs/index.cfm:407) 

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 cfact_repeatMaintenance2ecfm2016920000._factor8(C:\home\huroniapools.com\secure_html\eMerchant\srvRequest\act_repeatMaintenance.cfm:174)
	at cfact_repeatMaintenance2ecfm2016920000._factor11(C:\home\huroniapools.com\secure_html\eMerchant\srvRequest\act_repeatMaintenance.cfm:20)
	at cfact_repeatMaintenance2ecfm2016920000._factor12(C:\home\huroniapools.com\secure_html\eMerchant\srvRequest\act_repeatMaintenance.cfm:1)
	at cfact_repeatMaintenance2ecfm2016920000.runPage(C:\home\huroniapools.com\secure_html\eMerchant\srvRequest\act_repeatMaintenance.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 cftriggers2ecfm1966389557._factor40(C:\home\huroniapools.com\config\triggers.cfm:838)
	at cftriggers2ecfm1966389557.runPage(C:\home\huroniapools.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 cffooter12ecfm960507936.runPage(C:\home\huroniapools.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 cfindex2ecfm1539308683.runPage(C:\home\huroniapools.com\vs\index.cfm:407)
	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)