Email Us
Blogs tagged with "MAINTENANCE CHEMICALS"

The three treatments that we add each week (in addition to your balancing chemicals) are Stain&Scale Control, Algicide, and Pool Perfect Total.

 Stain&Scale control is used to re

(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:52 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)