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:/inetpub/wwwroot/products2.cfm: line 42
Called from C:/inetpub/wwwroot/products2.cfm: line 14
Called from C:/inetpub/wwwroot/products2.cfm: line 1
40 : select count(*) as cnt
41 : from tb_styles_web_taxonomy a with (nolock) left join tb_web_taxonomy b with (nolock) on (a.web_taxonomy_id=b.web_taxonomy_id)
42 : where style=<cfqueryparam value = "#url.id#" cfsqltype = "cf_sql_integer"> and b.dept='CLEARANCE CENTER' and UPPER(b.typ) like 'APPAREL%'
43 : </cfquery>
44 : 

Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.227.19.108
Referrer  
Date/Time   10-Jul-14 08:54 AM
Stack Trace
at cfproducts22ecfm199348766._factor20(C:/inetpub/wwwroot/products2.cfm:42) at cfproducts22ecfm199348766._factor25(C:/inetpub/wwwroot/products2.cfm:14) at cfproducts22ecfm199348766.runPage(C:/inetpub/wwwroot/products2.cfm:1)

coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:101)
	at coldfusion.sql.Parameter.getMappingValues(Parameter.java:51)
	at coldfusion.sql.InParameter.setStatement(InParameter.java:58)
	at coldfusion.sql.ParameterList.setStatement(ParameterList.java:108)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1435)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfproducts22ecfm199348766._factor20(C:\inetpub\wwwroot\products2.cfm:42)
	at cfproducts22ecfm199348766._factor25(C:\inetpub\wwwroot\products2.cfm:14)
	at cfproducts22ecfm199348766.runPage(C:\inetpub\wwwroot\products2.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:201)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doRequestNoFilter(FusionReactorCoreFilter.java:712)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:341)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)