Email Us
Postings In April 2023

Perfect Poolside Snacks
April 01/2023
Eating healthy by your swimming pool can be fun and easy and delicious. Finding the perfect poolside snack however isn’t easy. The ideal snack should be light, refreshing, easily digestible and of course it has to be tasty. This Summer look like a super star chef with these
(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:45 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)