fb
Image

$0.00
Out of stock

Renegade Stores is a cutting edge western and work store, specializing in NEW, first-quality, fashion-forward western and work apparel, accessories, and footwear for the entire family. We offer your favorite brands at great prices, accompanied by incredible midwestern service. Our philosophy is: 'The most important thing that we sell is a return visit or follow up order'. We take a great deal of pride in personally handling your orders. We want you to know that YOUR orders are as important to us as they are to you. We will work hard everyday to earn & keep your business; We guarantee it!! Renegade was founded with the mission of leading the industry in fashionable & functional merchandise brought to YOU at an everyday great value. You don't have to wait for a sale to know you're getting a GREAT DEAL!! The friendly, knowledgeable staff at RENEGADE has over 135 years of combined western, work & retail experience. WE LOVE WHAT WE DO!! If you are not comfortable making purchases online or have questions, please call us TOLL FREE at 888-371-0866, and a sales associate will be available Monday through Friday from 9:30 am to 7:00 pm CST to help you. We ask for your business, and we will work hard everyday to keep it!

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 error occurred in C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 817
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 807
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 1
Called from C:/home/renegadestores.com/wwwroot/router.cfm: line 16
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 817
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 807
Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 1
Called from C:/home/renegadestores.com/wwwroot/router.cfm: line 16
815 : 		left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1
816 : 		left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90
817 : 		where s.web_product='Y' and s.style_id in(#product.STYLE_ID#)
818 : 		and (b90.QOH > 0 OR b.QOH > 0)
819 : 		group by s.style_id

SQLSTATE   HY000
DATASOURCE   renegadecumdedicated
VENDORERRORCODE   102
SQL    Select CASE when MIN(b90.PRICE) > 0 then MIN(b90.PRICE) else MIN(b.PRICE) END AS MIN_PRICE, CASE when MAX(b90.PRICE) > 0 then MAX(b90.PRICE) else MAX(b.PRICE) END AS MAX_PRICE, CASE when MAX(b90.PRICE) > 0 then MAX(b90.PRICE) else MAX(b.PRICE) END AS PRICE from tb_styles s with(nolock) left join tb_skus sk with(nolock) on sk.style_id = s.style_id left join tb_sku_lookups sl with (nolock) on (sl.sku_id=sk.SKU_ID and len(sl.lookup) > 10) left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1 left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90 where s.web_product='Y' and s.style_id in() and (b90.QOH > 0 OR b.QOH > 0) group by s.style_id
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   18.97.9.175
Referrer  
Date/Time   06-Dec-24 08:45 AM
Stack Trace
at cffooter2ecfm204508901._factor16(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:817) at cffooter2ecfm204508901._factor20(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:807) at cffooter2ecfm204508901.runPage(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:1) at cfrouter2ecfm1479502796.runPage(C:/home/renegadestores.com/wwwroot/router.cfm:16) at cffooter2ecfm204508901._factor16(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:817) at cffooter2ecfm204508901._factor20(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:807) at cffooter2ecfm204508901.runPage(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:1) at cfrouter2ecfm1479502796.runPage(C:/home/renegadestores.com/wwwroot/router.cfm:16)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
	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.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cffooter2ecfm204508901._factor16(C:\home\renegadestores.com\wwwroot\includes\footer.cfm:817)
	at cffooter2ecfm204508901._factor20(C:\home\renegadestores.com\wwwroot\includes\footer.cfm:807)
	at cffooter2ecfm204508901.runPage(C:\home\renegadestores.com\wwwroot\includes\footer.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfrouter2ecfm1479502796.runPage(C:\home\renegadestores.com\wwwroot\router.cfm:16)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
	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:96)
	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:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	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:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)