Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'UNION'.
 
The error occurred in C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm: line 49
Called from C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm: line 178
Called from C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm: line 49
Called from C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm: line 178
47 :         where CC.type = 1
48 :       ) as row_num_table
49 :     WHERE row_num BETWEEN (#results_per_page# * (#page_num# - 1) + 1) AND (#results_per_page# * #page_num#)
50 : </cfquery>
51 : <cfoutput>

VENDORERRORCODE   156
SQLSTATE   HY000
SQL    with cte_catas ( id, type, name ) AS (select id, type, name from [ASO_P].[dbo].[cata] AS P where is_online = 1 and parent_id = UNION ALL SELECT P.id, P.type, p.name FROM cte_catas C INNER JOIN [ASO_P].[dbo].[cata] AS P ON C.id = P.parent_id where P.is_online = 1 and P.parent_id <> 0 ) SELECT row_num, id, description, price, item_category from (SELECT ROW_NUMBER() OVER(ORDER BY (select NULL as noorder)) as row_num, I.id as id, I.description as description, I.price as price, I.cata_fid as item_category FROM cte_catas CC JOIN items I on I.cata_fid = CC.id where CC.type = 1 ) as row_num_table WHERE row_num BETWEEN (100 * (1 - 1) + 1) AND (100 * 1)
DATASOURCE   ASO_P
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.162.139.105
Referrer  
Date/Time   23-Nov-17 05:44 PM
Stack Trace
at cfcatalog_info_cata2ecfm1520010967.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm:49) at cfcatalog2ecfm1855366439.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm:178) at cfcatalog_info_cata2ecfm1520010967.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog_info_cata.cfm:49) at cfcatalog2ecfm1855366439.runPage(C:/inetpub/wwwroot/beta.artsuppliesonline.com/site/catalog.cfm:178)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'UNION'.
	at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.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.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1442)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1056)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:990)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:677)
	at cfcatalog_info_cata2ecfm1520010967.runPage(C:\inetpub\wwwroot\beta.artsuppliesonline.com\site\catalog_info_cata.cfm:49)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cfcatalog2ecfm1855366439.runPage(C:\inetpub\wwwroot\beta.artsuppliesonline.com\site\catalog.cfm:178)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:443)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:204)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	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:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:203)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)