fb
Image

$0.00
Out of stock

you may also like

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!

    Renegade | Cart 0 Login / Register

    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 840
    Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 830
    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 840
    Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 830
    Called from C:/home/renegadestores.com/wwwroot/includes/footer.cfm: line 1
    Called from C:/home/renegadestores.com/wwwroot/router.cfm: line 16
    		 
    838 : 		left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1
839 : 		left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90
840 : 		where s.web_product='Y' and s.style_id in(#product.STYLE_ID#)
841 : 		and (b90.QOH > 0 OR b.QOH > 0)
842 : 		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.14.87
    Referrer  
    Date/Time   23-Jun-25 01:24 AM
    Stack Trace
    at cffooter2ecfm204508901._factor16(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:840) at cffooter2ecfm204508901._factor20(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:830) 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:840) at cffooter2ecfm204508901._factor20(C:/home/renegadestores.com/wwwroot/includes/footer.cfm:830) 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:840)
	at cffooter2ecfm204508901._factor20(C:\home\renegadestores.com\wwwroot\includes\footer.cfm:830)
	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)