HOME

lacrosse apparel


Sharpen your results using the search tools below:

Category PLEASE SELECT A CATEGORY

Brands PLEASE SELECT A BRAND

Price Range SLIDE BAR FOR PRICE RANGE

$3.00 to $90.00

Color PLEASE SELECT A COLOR


Size PLEASE SELECT A SIZE



Lacrosse Apparel
  • Get the gear you want, at the prices you want. Lacrosse clothing & apparel from ComLAX gives you plenty of options to standout during practice, games, or in your trophy room. Choose from our huge selection of men's and women's Lacrosse clothes.

Sort By:  


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]The DBMS returned an unspecified error. The command code was 193.
 
The error occurred in C:/inetpub/wwwroot/ComLax/category_ext.cfm: line 229
Called from C:/inetpub/wwwroot/ComLax/category.cfm: line 171
Called from C:/inetpub/wwwroot/ComLax/category_ext.cfm: line 229
Called from C:/inetpub/wwwroot/ComLax/category.cfm: line 171
227 :                 left join tb_sku_buckets e on (e.sku_id = a.sku_id)
228 :                 where a.style_id = #val(getproducts.style_id)# and e.price>0
229 :                 and e.store_id =#application.pricing_store#
230 :                 group by a.style_id
231 :                 <!---<cfif allow_out_of_stock is 'NO'>

SQLSTATE   08006
SQL    select a.style_id , max(b.of1) as of1 , max(b.of15) as of15 , max(b.of19) as of19 , min(e.price) as minprice , max(e.price) as max_regprice , max(e.store_price) as maxprice ,min(e.sugg_price) as sugg_price1 ,max(e.sugg_price) as sugg_price2 , max(e.store_price) as max_store_price , sum(e.qoh) as qoh from tb_skus a left join tb_styles b on (a.style_id = b.style_id) left join tb_sku_buckets e on (e.sku_id = a.sku_id) where a.style_id = 25547 and e.price>0 and e.store_id =26 group by a.style_id order by a.style_id
DATASOURCE   CelerantSQL
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.144.254.112
Referrer  
Date/Time   06-Mar-15 01:00 AM
Stack Trace
at cfcategory_ext2ecfm38516202.runPage(C:/inetpub/wwwroot/ComLax/category_ext.cfm:229) at cfcategory2ecfm504834824.runPage(C:/inetpub/wwwroot/ComLax/category.cfm:171) at cfcategory_ext2ecfm38516202.runPage(C:/inetpub/wwwroot/ComLax/category_ext.cfm:229) at cfcategory2ecfm504834824.runPage(C:/inetpub/wwwroot/ComLax/category.cfm:171)

java.sql.SQLNonTransientConnectionException: [macromedia][SQLServer JDBC Driver]The DBMS returned an unspecified error.  The command code was 193.
	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.c(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.r(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:1464)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1223)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1153)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1158)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1092)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:782)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:745)
	at cfcategory_ext2ecfm38516202.runPage(C:\inetpub\wwwroot\ComLax\category_ext.cfm:229)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:734)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:570)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2986)
	at cfcategory2ecfm504834824.runPage(C:\inetpub\wwwroot\ComLax\category.cfm:171)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:734)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:570)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:141)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	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:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:198)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)