Email Us
Postings In January 2021

We know the winter months can be a bit dull. While you and your special someone are impatiently awaiting the annual arrival of summer, take some time to reconnect with th
(0)


Let's face it; many of us are procrastinators. We like to put things off until the very last minute and then scramble to get it done in a panic. Why do we bring this added stress into our lives when a little forethought could make things much easier? This is particularly tru
(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:02 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)