Email Us
Postings In Maintenance

Phosphates are chemical compounds that contain phosphorus, an essential nutrient for plants and organisms. In the context of swimming pools, phosphates are often referred to as "pool phosphates" or "phosphate levels."
Phosphates can e
(0)


Perfect pool water is key to enjoying time with your friends and family in the swimming pool. A swim with friends on a hot day can be a wonderful treat and create a fun memory. Don’t let it be ruined by poor water quality.  Often people over c
(0)


Finding a leak in a pool liner can be a bit of a process, but here are some steps you can follow to locate the source of the leak:Visual Inspection: Begin by conducting a visual inspection of the pool liner. Look for any obvi
(0)


Having a sparkling, clean pool is a dream come true for any pool owner. However, one common issue that can turn this dream into a nightmare is the presence of algae. Algae can quickly take over your pool, turning the water
(0)


Cleaning up is never fun but we are going to make opening your swimming pool as simple as possible. In fact if you closed or winterized / closed your pool last fall all you have to do is the reverse this spring and you'll avoid a green algae filled pool. A key is to open you
(0)


If you’re thinking, “Phosphates in my pool water?” then this article is for you. The truth is that there will always be some phosphates in your pool. The key is keeping them under control. Why?Phosphates are one of the most abundant products on our planet. But you may be won
(0)


What if your pool could have cleaner, clearer water while actually using less chemicals? Most pool owners would jump at that opportunity. The technology that makes this possible is a combination of ultraviolet light (UV) and ozone gas (O3). Before we get into the technical s
(0)


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

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.

 
The error occurred in C:/home/greatvalleypool.com/config/triggers.cfm: line 547
Called from C:/home/greatvalleypool.com/config/triggers.cfm: line 508
Called from C:/home/greatvalleypool.com/config/triggers.cfm: line 1
Called from C:/home/greatvalleypool.com/config/footer1.cfm: line 39
Called from C:/home/greatvalleypool.com/blog/index.cfm: line 226
Called from C:/home/greatvalleypool.com/blog/index.cfm: line 1
545 : 			<cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#" name="getAProfile">
546 : 				insert into ARM_profiles(fname, lname, email, mainPurchase, repFname, repID, campaignID, pipelineID, rb)
547 : 				values(<cfqueryparam value="#FirstName#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#LastName#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#Email#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#getCampaignID.campaignType#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#repFname#" cfsqltype="cf_sql_varchar">, <cfqueryparam value="#repID#" cfsqltype="cf_sql_integer">, <cfqueryparam value="#getCampaignID.id#" cfsqltype="cf_sql_integer">, 0, 1)	
548 : 			</cfquery>
549 : 			<cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#" name="getProfileID">

Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   100.26.176.111
Referrer  
Date/Time   25-Jul-24 11:49 AM
Stack Trace
at cftriggers2ecfm1647911798._factor28(C:/home/greatvalleypool.com/config/triggers.cfm:547) at cftriggers2ecfm1647911798._factor39(C:/home/greatvalleypool.com/config/triggers.cfm:508) at cftriggers2ecfm1647911798.runPage(C:/home/greatvalleypool.com/config/triggers.cfm:1) at cffooter12ecfm432844128.runPage(C:/home/greatvalleypool.com/config/footer1.cfm:39) at cfindex2ecfm1577203132._factor16(C:/home/greatvalleypool.com/blog/index.cfm:226) at cfindex2ecfm1577203132.runPage(C:/home/greatvalleypool.com/blog/index.cfm:1)

coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:121)
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:70)
	at coldfusion.sql.Parameter.getMappingValues(Parameter.java:63)
	at coldfusion.sql.InParameter.setStatement(InParameter.java:72)
	at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1638)
	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 cftriggers2ecfm1647911798._factor28(C:\home\greatvalleypool.com\config\triggers.cfm:547)
	at cftriggers2ecfm1647911798._factor39(C:\home\greatvalleypool.com\config\triggers.cfm:508)
	at cftriggers2ecfm1647911798.runPage(C:\home\greatvalleypool.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 cffooter12ecfm432844128.runPage(C:\home\greatvalleypool.com\config\footer1.cfm:39)
	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 cfindex2ecfm1577203132._factor16(C:\home\greatvalleypool.com\blog\index.cfm:226)
	at cfindex2ecfm1577203132.runPage(C:\home\greatvalleypool.com\blog\index.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.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)