mitchell and ness

Griffey Jr Red Reds Replica Jersey

Style# 18307-CRESCAR00KGJ

$110.00

Write a Review
mitchell and ness

Griffey Jr Red Reds Replica Jersey

Style# 18307-CRESCAR00KGJ

$110.00

Write a Review

Color : RED

Option: REDS

MD LG XL XXL
Add to Cart Check Store Availability Add to Wish List
FREE SHIPPING on orders of $50+ See Details

Find In Store Shipping & Returns
Facebook Twitter LinkedIn Pinterest
Product Features & description

 

  • 100% polyester mesh body
  • Twill logo, name, and number
  • Woven jocktag on lower left hem
  • Machine washable on cold; Tumble dry on low
  • Button up front and rounded hem
  • Officially licensed by the MLB
reviews
  • Description
  • Reviews

 

  • 100% polyester mesh body
  • Twill logo, name, and number
  • Woven jocktag on lower left hem
  • Machine washable on cold; Tumble dry on low
  • Button up front and rounded hem
  • Officially licensed by the MLB

SHOE SIZING CHART by brand

 

 

 

 

We Also Recommend
struct
EVENTNAME onRequest
EXCEPTION
struct
Cause
struct
Cause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource celerantSQL
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
2
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Message Error Executing Database Query.
NativeErrorCode 156
RootCause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql select sum(c.price ) as price,sum(c.avg_cost) as avg_cost,sum(c.qr) as qr,sum(c.qoo) as qoo,sum(c.qoh) as qoh,sum(c.qc) as qc,(sum(c.qoh)-sum(c.qc)) as qavail, b.sku_id,d.LOOKUP,e.attr1,e.ATTR1_ALIAS,f.siz,f.SIZ_ALIAS,g.PICTURE_FILE as MainImg,h.PICTURE_FILE as MainColorImg from tb_styles a inner join tb_skus b with(nolock) on (a.style_id=b.style_id) inner join tb_sku_buckets c with(nolock) on (b.sku_id=c.sku_id) left join TB_SKU_LOOKUPS d with(nolock) on (b.sku_id=d.sku_id and d.PRIME='Y') left join TB_ATTR1_ENTRIES e with(nolock) on (b.ATTR1_ENTRY_ID=e.ATTR1_ENTRY_ID) left join TB_SIZE_ENTRIES f with(nolock) on (b.SCALE_ENTRY_ID=f.SCALE_ENTRY_ID) left join tb_alt_pictures g with(noLock) on (a.style_id=g.style_id and g.pic_desc = 'DEFAULT' and g.ATTR1_ENTRY_ID is null) left join tb_alt_pictures h with(noLock) on (a.style_id=h.style_id and h.pic_desc = 'DEFAULT' where a.style_id= (param 1) and c.store_id in ( (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) ) group by b.sku_id,d.LOOKUP,e.attr1,e.ATTR1_ALIAS,f.siz,f.SIZ_ALIAS,g.PICTURE_FILE,h.PICTURE_FILE
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 63 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
where (param 1) = [type='IN', class='java.lang.Integer', value='81357', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 4) = [type='IN', class='java.lang.Integer', value='5', sqltype='cf_sql_integer'] , (param 5) = [type='IN', class='java.lang.Integer', value='6', sqltype='cf_sql_integer'] , (param 6) = [type='IN', class='java.lang.Integer', value='8', sqltype='cf_sql_integer'] , (param 7) = [type='IN', class='java.lang.Integer', value='9', sqltype='cf_sql_integer'] , (param 8) = [type='IN', class='java.lang.Integer', value='11', sqltype='cf_sql_integer'] , (param 9) = [type='IN', class='java.lang.Integer', value='12', sqltype='cf_sql_integer'] , (param 10) = [type='IN', class='java.lang.Integer', value='14', sqltype='cf_sql_integer'] , (param 11) = [type='IN', class='java.lang.Integer', value='15', sqltype='cf_sql_integer'] , (param 12) = [type='IN', class='java.lang.Integer', value='18', sqltype='cf_sql_integer'] , (param 13) = [type='IN', class='java.lang.Integer', value='19', sqltype='cf_sql_integer'] , (param 14) = [type='IN', class='java.lang.Integer', value='20', sqltype='cf_sql_integer'] , (param 15) = [type='IN', class='java.lang.Integer', value='88', sqltype='cf_sql_integer'] , (param 16) = [type='IN', class='java.lang.Integer', value='89', sqltype='cf_sql_integer'] , (param 17) = [type='IN', class='java.lang.Integer', value='1000', sqltype='cf_sql_integer']
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
struct
Cause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource celerantSQL
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
2
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Message Error Executing Database Query.
NativeErrorCode 156
RootCause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql select sum(c.price ) as price,sum(c.avg_cost) as avg_cost,sum(c.qr) as qr,sum(c.qoo) as qoo,sum(c.qoh) as qoh,sum(c.qc) as qc,(sum(c.qoh)-sum(c.qc)) as qavail, b.sku_id,d.LOOKUP,e.attr1,e.ATTR1_ALIAS,f.siz,f.SIZ_ALIAS,g.PICTURE_FILE as MainImg,h.PICTURE_FILE as MainColorImg from tb_styles a inner join tb_skus b with(nolock) on (a.style_id=b.style_id) inner join tb_sku_buckets c with(nolock) on (b.sku_id=c.sku_id) left join TB_SKU_LOOKUPS d with(nolock) on (b.sku_id=d.sku_id and d.PRIME='Y') left join TB_ATTR1_ENTRIES e with(nolock) on (b.ATTR1_ENTRY_ID=e.ATTR1_ENTRY_ID) left join TB_SIZE_ENTRIES f with(nolock) on (b.SCALE_ENTRY_ID=f.SCALE_ENTRY_ID) left join tb_alt_pictures g with(noLock) on (a.style_id=g.style_id and g.pic_desc = 'DEFAULT' and g.ATTR1_ENTRY_ID is null) left join tb_alt_pictures h with(noLock) on (a.style_id=h.style_id and h.pic_desc = 'DEFAULT' where a.style_id= (param 1) and c.store_id in ( (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param 15) , (param 16) , (param 17) ) group by b.sku_id,d.LOOKUP,e.attr1,e.ATTR1_ALIAS,f.siz,f.SIZ_ALIAS,g.PICTURE_FILE,h.PICTURE_FILE
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 63 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'.
where (param 1) = [type='IN', class='java.lang.Integer', value='81357', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='3', sqltype='cf_sql_integer'] , (param 4) = [type='IN', class='java.lang.Integer', value='5', sqltype='cf_sql_integer'] , (param 5) = [type='IN', class='java.lang.Integer', value='6', sqltype='cf_sql_integer'] , (param 6) = [type='IN', class='java.lang.Integer', value='8', sqltype='cf_sql_integer'] , (param 7) = [type='IN', class='java.lang.Integer', value='9', sqltype='cf_sql_integer'] , (param 8) = [type='IN', class='java.lang.Integer', value='11', sqltype='cf_sql_integer'] , (param 9) = [type='IN', class='java.lang.Integer', value='12', sqltype='cf_sql_integer'] , (param 10) = [type='IN', class='java.lang.Integer', value='14', sqltype='cf_sql_integer'] , (param 11) = [type='IN', class='java.lang.Integer', value='15', sqltype='cf_sql_integer'] , (param 12) = [type='IN', class='java.lang.Integer', value='18', sqltype='cf_sql_integer'] , (param 13) = [type='IN', class='java.lang.Integer', value='19', sqltype='cf_sql_integer'] , (param 14) = [type='IN', class='java.lang.Integer', value='20', sqltype='cf_sql_integer'] , (param 15) = [type='IN', class='java.lang.Integer', value='88', sqltype='cf_sql_integer'] , (param 16) = [type='IN', class='java.lang.Integer', value='89', sqltype='cf_sql_integer'] , (param 17) = [type='IN', class='java.lang.Integer', value='1000', sqltype='cf_sql_integer']
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:309) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:470) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489) at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676) at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011) at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:301) ... 34 more Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'where'. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1501) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816) ... 63 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 738
RAW_TRACE at cfitemDetails2ecfc1879083725$funcGETSKUDATA.runFunction(E:\websites\functions\itemDetails.cfc:738)
TEMPLATE E:\websites\functions\itemDetails.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 676
RAW_TRACE at cfproducts2ecfm415093963._factor19(E:\websites\defaultWebsite\products.cfm:676)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_PRODUCTS
LINE 675
RAW_TRACE at cfproducts2ecfm415093963.runPage(E:\websites\defaultWebsite\products.cfm:675)
TEMPLATE E:\websites\defaultWebsite\products.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 482
RAW_TRACE at cfapplication2ecfc567724491$funcONREQUEST.runFunction(E:\websites\application.cfc:482)
TEMPLATE E:\websites\application.cfc
TYPE CFML
Type Database
name onRequest