struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1364) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) 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 cfqry_GetProductList2ecfm767439232.runPage(D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm:22) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfFBX_Switch2ecfm283900169._factor7(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:80) at cfFBX_Switch2ecfm283900169._factor26(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:79) at cfFBX_Switch2ecfm283900169.runPage(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cffbx_fusebox30_CF502ecfm837592123._factor5(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:242) at cffbx_fusebox30_CF502ecfm837592123._factor6(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:2) at cffbx_fusebox30_CF502ecfm837592123.runPage(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfindex2ecfm1515992511.runPage(D:\Inetpub\evitalhealth\index.cfm:7) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:399) 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:78) 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.FusionReactorFilter.c(FusionReactorFilter.java:428) at com.intergral.fusionreactor.filter.FusionReactorFilter.d(FusionReactorFilter.java:262) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:171) 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)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 22
RAW_TRACE at cfqry_GetProductList2ecfm767439232.runPage(D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm:22)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 80
RAW_TRACE at cfFBX_Switch2ecfm283900169._factor7(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:80)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_FBX_SWITCH
LINE 79
RAW_TRACE at cfFBX_Switch2ecfm283900169._factor26(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:79)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_FBX_SWITCH
LINE 1
RAW_TRACE at cfFBX_Switch2ecfm283900169.runPage(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:1)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 242
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123._factor5(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:242)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_FBX_FUSEBOX30_CF50
LINE 2
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123._factor6(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:2)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_FBX_FUSEBOX30_CF50
LINE 1
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123.runPage(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:1)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 7
RAW_TRACE at cfindex2ecfm1515992511.runPage(D:\Inetpub\evitalhealth\index.cfm:7)
TEMPLATE D:\Inetpub\evitalhealth\index.cfm
TYPE CFML
Type java.sql.SQLException
DataSource evital
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
ErrorCode HY000
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1364) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) 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 cfqry_GetProductList2ecfm767439232.runPage(D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm:22) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfFBX_Switch2ecfm283900169._factor7(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:80) at cfFBX_Switch2ecfm283900169._factor26(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:79) at cfFBX_Switch2ecfm283900169.runPage(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cffbx_fusebox30_CF502ecfm837592123._factor5(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:242) at cffbx_fusebox30_CF502ecfm837592123._factor6(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:2) at cffbx_fusebox30_CF502ecfm837592123.runPage(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfindex2ecfm1515992511.runPage(D:\Inetpub\evitalhealth\index.cfm:7) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:399) 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:78) 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.FusionReactorFilter.c(FusionReactorFilter.java:428) at com.intergral.fusionreactor.filter.FusionReactorFilter.d(FusionReactorFilter.java:262) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:171) 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)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 22
RAW_TRACE at cfqry_GetProductList2ecfm767439232.runPage(D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm:22)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 80
RAW_TRACE at cfFBX_Switch2ecfm283900169._factor7(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:80)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_FBX_SWITCH
LINE 79
RAW_TRACE at cfFBX_Switch2ecfm283900169._factor26(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:79)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_FBX_SWITCH
LINE 1
RAW_TRACE at cfFBX_Switch2ecfm283900169.runPage(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:1)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 242
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123._factor5(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:242)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_FBX_FUSEBOX30_CF50
LINE 2
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123._factor6(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:2)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_FBX_FUSEBOX30_CF50
LINE 1
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123.runPage(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:1)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 7
RAW_TRACE at cfindex2ecfm1515992511.runPage(D:\Inetpub\evitalhealth\index.cfm:7)
TEMPLATE D:\Inetpub\evitalhealth\index.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT SC_Products.ProductID AS ProductCode,SC_Products.ID AS ProductID, SC_Products.Name AS ProductName, SC_Products.Price AS ProductPrice, SC_Products.Sale AS SalePrice, SC_Categories.ProductCategoryName AS CatName, SC_Categories.ProductCategoryName AS SearchTerm,SC_Products.Type,SC_Products.Size,Sc_Products.Image, sc_Vendors.name AS Vendor,SC_Products.VendorID, sc_Vendors.SEOVendor,SC_Products.SEOName,SC_Products.restricted FROM SC_Products INNER JOIN SC_ProductCategories ON SC_ProductCategories.ProductID = SC_Products.ID INNER JOIN SC_Categories ON SC_Categories.ProductCategoryID = SC_ProductCategories.CategoryID INNER JOIN sc_Vendors ON sc_Vendors.ID = SC_Products.vendorid WHERE SC_ProductCategories.CategoryID IN () AND SC_Products.Active = 1 ORDER BY SC_Products.Name;
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfqry_GetProductList2ecfm767439232.runPage(D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm:22) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfFBX_Switch2ecfm283900169._factor7(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:80) at cfFBX_Switch2ecfm283900169._factor26(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:79) at cfFBX_Switch2ecfm283900169.runPage(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cffbx_fusebox30_CF502ecfm837592123._factor5(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:242) at cffbx_fusebox30_CF502ecfm837592123._factor6(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:2) at cffbx_fusebox30_CF502ecfm837592123.runPage(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfindex2ecfm1515992511.runPage(D:\Inetpub\evitalhealth\index.cfm:7) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:399) 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:78) 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.FusionReactorFilter.c(FusionReactorFilter.java:428) at com.intergral.fusionreactor.filter.FusionReactorFilter.d(FusionReactorFilter.java:262) at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:171) 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) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.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.ddm.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1364) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) 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) ... 52 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 22
RAW_TRACE at cfqry_GetProductList2ecfm767439232.runPage(D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm:22)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\qry_GetProductList.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 80
RAW_TRACE at cfFBX_Switch2ecfm283900169._factor7(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:80)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_FBX_SWITCH
LINE 79
RAW_TRACE at cfFBX_Switch2ecfm283900169._factor26(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:79)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_FBX_SWITCH
LINE 1
RAW_TRACE at cfFBX_Switch2ecfm283900169.runPage(D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm:1)
TEMPLATE D:\Inetpub\evitalhealth\Shopping\FBX_Switch.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 242
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123._factor5(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:242)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_FBX_FUSEBOX30_CF50
LINE 2
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123._factor6(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:2)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
7
struct
COLUMN 0
ID CF_FBX_FUSEBOX30_CF50
LINE 1
RAW_TRACE at cffbx_fusebox30_CF502ecfm837592123.runPage(D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm:1)
TEMPLATE D:\Inetpub\evitalhealth\fbx_fusebox30_CF50.cfm
TYPE CFML
8
struct
COLUMN 0
ID CFINCLUDE
LINE 7
RAW_TRACE at cfindex2ecfm1515992511.runPage(D:\Inetpub\evitalhealth\index.cfm:7)
TEMPLATE D:\Inetpub\evitalhealth\index.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
where [empty string]