Join Our List

Receive updates on the latest products, deals,
and exclusive daily deal discounts.

No thanks

You're Subscribed

Thanks for shopping with Sc Arms

Welcome to SC Arms!

Image

Be the first to leave a review!

product code:

UPC:

Brand:

View more from

availability: Currently out of Stock

$0.00
OUT OF STOCK

Email:

Leave a Review!

Name: Email:
Review Title: Review: Rating:
struct
Cause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfvendproduct2ecfm1001102007._factor42(C:\home\scarms.com\wwwroot\vendproduct.cfm:1140) at cfvendproduct2ecfm1001102007._factor43(C:\home\scarms.com\wwwroot\vendproduct.cfm:1) at cfvendproduct2ecfm1001102007.runPage(C:\home\scarms.com\wwwroot\vendproduct.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfrouter2ecfm617317667.runPage(C:\home\scarms.com\wwwroot\router.cfm:24) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CFQUERY
LINE 1140
RAW_TRACE at cfvendproduct2ecfm1001102007._factor42(C:\home\scarms.com\wwwroot\vendproduct.cfm:1140)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
15
struct
COLUMN 0
ID CF_VENDPRODUCT
LINE 1
RAW_TRACE at cfvendproduct2ecfm1001102007._factor43(C:\home\scarms.com\wwwroot\vendproduct.cfm:1)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
16
struct
COLUMN 0
ID CF_VENDPRODUCT
LINE 1
RAW_TRACE at cfvendproduct2ecfm1001102007.runPage(C:\home\scarms.com\wwwroot\vendproduct.cfm:1)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
17
struct
COLUMN 0
ID CFINCLUDE
LINE 24
RAW_TRACE at cfrouter2ecfm617317667.runPage(C:\home\scarms.com\wwwroot\router.cfm:24)
TEMPLATE C:\home\scarms.com\wwwroot\router.cfm
TYPE CFML
Type java.sql.SQLException
DataSource scarmsicumulus
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
Message Error Executing Database Query.
NativeErrorCode 156
RootCause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfvendproduct2ecfm1001102007._factor42(C:\home\scarms.com\wwwroot\vendproduct.cfm:1140) at cfvendproduct2ecfm1001102007._factor43(C:\home\scarms.com\wwwroot\vendproduct.cfm:1) at cfvendproduct2ecfm1001102007.runPage(C:\home\scarms.com\wwwroot\vendproduct.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfrouter2ecfm617317667.runPage(C:\home\scarms.com\wwwroot\router.cfm:24) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
2
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
3
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
4
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
5
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CFQUERY
LINE 1140
RAW_TRACE at cfvendproduct2ecfm1001102007._factor42(C:\home\scarms.com\wwwroot\vendproduct.cfm:1140)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
15
struct
COLUMN 0
ID CF_VENDPRODUCT
LINE 1
RAW_TRACE at cfvendproduct2ecfm1001102007._factor43(C:\home\scarms.com\wwwroot\vendproduct.cfm:1)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
16
struct
COLUMN 0
ID CF_VENDPRODUCT
LINE 1
RAW_TRACE at cfvendproduct2ecfm1001102007.runPage(C:\home\scarms.com\wwwroot\vendproduct.cfm:1)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
17
struct
COLUMN 0
ID CFINCLUDE
LINE 24
RAW_TRACE at cfrouter2ecfm617317667.runPage(C:\home\scarms.com\wwwroot\router.cfm:24)
TEMPLATE C:\home\scarms.com\wwwroot\router.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql Select top 6 s.style_id, max(description) as description,max(PICTURE_ID) as PICTURE_ID, max(b.price) as price,max(s.style) as style ,max(brand) as brand from tb_styles s with(nolock) join tb_skus sk with(nolock) on sk.style_id = s.style_id join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id join TB_ECOMM_PRODUCT_INFO epi on s.style_id = epi.STYLE_ID where s.web_product='Y' and s.style_id in ( Select style_id from TB_ECOMM_PRODUCT_TAXONOMY wt join TB_ECOMM_TAXONOMY t with(nolock) on wt.ECOMM_TAXONOMY_ID = t.ECOMM_TAXONOMY_ID where t.Dept = '' and s.style_id != and t.typ in ('') ) and b.QOH > 0 group by s.style_id ORDER BY NewID()
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfvendproduct2ecfm1001102007._factor42(C:\home\scarms.com\wwwroot\vendproduct.cfm:1140) at cfvendproduct2ecfm1001102007._factor43(C:\home\scarms.com\wwwroot\vendproduct.cfm:1) at cfvendproduct2ecfm1001102007.runPage(C:\home\scarms.com\wwwroot\vendproduct.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cfrouter2ecfm617317667.runPage(C:\home\scarms.com\wwwroot\router.cfm:24) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:447) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1826) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1189) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:658) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1649) at coldfusion.sql.Executive.executeQuery(Executive.java:1391) at coldfusion.sql.Executive.executeQuery(Executive.java:1321) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877) ... 49 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 1140
RAW_TRACE at cfvendproduct2ecfm1001102007._factor42(C:\home\scarms.com\wwwroot\vendproduct.cfm:1140)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
2
struct
COLUMN 0
ID CF_VENDPRODUCT
LINE 1
RAW_TRACE at cfvendproduct2ecfm1001102007._factor43(C:\home\scarms.com\wwwroot\vendproduct.cfm:1)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
3
struct
COLUMN 0
ID CF_VENDPRODUCT
LINE 1
RAW_TRACE at cfvendproduct2ecfm1001102007.runPage(C:\home\scarms.com\wwwroot\vendproduct.cfm:1)
TEMPLATE C:\home\scarms.com\wwwroot\vendproduct.cfm
TYPE CFML
4
struct
COLUMN 0
ID CFINCLUDE
LINE 24
RAW_TRACE at cfrouter2ecfm617317667.runPage(C:\home\scarms.com\wwwroot\router.cfm:24)
TEMPLATE C:\home\scarms.com\wwwroot\router.cfm
TYPE CFML
5
struct
COLUMN 0
ID ??
LINE 1103
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
6
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 980
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
7
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1124
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
8
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 193
RAW_TRACE at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
9
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1153
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
10
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4126
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
11
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4275
RAW_TRACE at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
12
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2035
RAW_TRACE at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
13
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 632
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
14
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2699
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
15
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 2508
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
16
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 1358
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
17
struct
COLUMN 0
ID CF_|SQLSERVER|6.0.0
LINE 4478
RAW_TRACE at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE |SQLServer|6.0.0.1282|
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'and'.
where [empty string]