<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <%@ include file="Connections/bidango.htm" %> <% String rsSearch__c = "sunglasses"; if (request.getParameter("c") !=null) {rsSearch__c = (String)request.getParameter("c") ;} %> <% String rsSearch__b = "%"; if (request.getParameter("b") !=null) {rsSearch__b = (String)request.getParameter("b") ;} %> <% String rsSearch__g = "%"; if (request.getParameter("g") !=null) {rsSearch__g = (String)request.getParameter("g") ;} %> <% Driver DriverrsSearch = (Driver)Class.forName(MM_bidango_DRIVER).newInstance(); Connection ConnrsSearch = DriverManager.getConnection(MM_bidango_STRING,MM_bidango_USERNAME,MM_bidango_PASSWORD); PreparedStatement StatementrsSearch = ConnrsSearch.prepareStatement("SELECT * FROM products WHERE programname = 'USOUTDOOR.com' AND xcat3 LIKE('" + rsSearch__c + "') AND xcat4 LIKE('" + rsSearch__g + "') AND manufacturer LIKE('" + rsSearch__b + "') OR programname = 'BackcountryStore.com' AND xcat3 LIKE('" + rsSearch__c + "') AND xcat4 LIKE('" + rsSearch__g + "') AND manufacturer LIKE('" + rsSearch__b + "') ORDER BY xcat3, name, manufacturer"); ResultSet rsSearch = StatementrsSearch.executeQuery(); boolean rsSearch_isEmpty = !rsSearch.next(); boolean rsSearch_hasData = !rsSearch_isEmpty; Object rsSearch_data; Object currCategory; int fourCount = 0; int rsSearch_numRows = 0; %> <% String rsCategoryBrand__c = "sunglasses"; if (request.getParameter("c") !=null) {rsCategoryBrand__c = (String)request.getParameter("c");} %> <% String rsCategoryBrand__b = "%"; if (request.getParameter("b") !=null) {rsCategoryBrand__b = (String)request.getParameter("b");} %> <% String rsCategoryBrand__g = "%"; if (request.getParameter("g") !=null) {rsCategoryBrand__g = (String)request.getParameter("g");} %> <% Driver DriverrsCategoryBrand = (Driver)Class.forName(MM_bidango_DRIVER).newInstance(); Connection ConnrsCategoryBrand = DriverManager.getConnection(MM_bidango_STRING,MM_bidango_USERNAME,MM_bidango_PASSWORD); PreparedStatement StatementrsCategoryBrand = ConnrsCategoryBrand.prepareStatement("SELECT DISTINCT manufacturer FROM products WHERE programname = 'USOUTDOOR.com' AND xcat3 LIKE('" + rsCategoryBrand__c + "') AND xcat4 LIKE('" + rsCategoryBrand__g + "') AND manufacturer LIKE('" + rsCategoryBrand__b + "') OR programname = 'BackcountryStore.com' AND xcat3 LIKE('" + rsCategoryBrand__c + "') AND xcat4 LIKE('" + rsCategoryBrand__g + "') AND manufacturer LIKE('" + rsCategoryBrand__b + "') ORDER BY manufacturer "); ResultSet rsCategoryBrand = StatementrsCategoryBrand.executeQuery(); boolean rsCategoryBrand_isEmpty = !rsCategoryBrand.next(); boolean rsCategoryBrand_hasData = !rsCategoryBrand_isEmpty; Object rsCategoryBrand_data; int rsCategoryBrand_numRows = 0; %> <% String rsListSub__c = "sunglasses"; if (request.getParameter("c") !=null) {rsListSub__c = (String)request.getParameter("c");} %> <% String rsListSub__b = "%"; if (request.getParameter("b") !=null) {rsListSub__b = (String)request.getParameter("b");} %> <% Driver DriverrsListSub = (Driver)Class.forName(MM_bidango_DRIVER).newInstance(); Connection ConnrsListSub = DriverManager.getConnection(MM_bidango_STRING,MM_bidango_USERNAME,MM_bidango_PASSWORD); PreparedStatement StatementrsListSub = ConnrsListSub.prepareStatement("SELECT DISTINCT xcat4,xcat3 FROM products WHERE programname = 'USOUTDOOR.com' AND xcat3 LIKE('" + rsListSub__c + "') AND manufacturer LIKE('" + rsListSub__b + "') OR programname = 'BackcountryStore.com' AND xcat3 LIKE('" + rsListSub__c + "') AND manufacturer LIKE('" + rsListSub__b + "') ORDER BY xcat4"); ResultSet rsListSub = StatementrsListSub.executeQuery(); boolean rsListSub_isEmpty = !rsListSub.next(); boolean rsListSub_hasData = !rsListSub_isEmpty; Object rsListSub_data; int rsListSub_numRows = 0; %> <% int Repeat1__numRows = 12; int Repeat1__index = 0; rsSearch_numRows += Repeat1__numRows; %> <% int Repeat2__numRows = -1; int Repeat2__index = 0; rsCategoryBrand_numRows += Repeat2__numRows; %> <% int Repeat3__numRows = -1; int Repeat3__index = 0; rsListSub_numRows += Repeat3__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables int rsSearch_first = 1; int rsSearch_last = 1; int rsSearch_total = -1; if (rsSearch_isEmpty) { rsSearch_total = rsSearch_first = rsSearch_last = 0; } //set the number of rows displayed on this page if (rsSearch_numRows == 0) { rsSearch_numRows = 1; } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (rsSearch_total == -1) { // count the total records by iterating through the recordset for (rsSearch_total = 1; rsSearch.next(); rsSearch_total++); // reset the cursor to the beginning rsSearch.close(); rsSearch = StatementrsSearch.executeQuery(); rsSearch_hasData = rsSearch.next(); // set the number of rows displayed on this page if (rsSearch_numRows < 0 || rsSearch_numRows > rsSearch_total) { rsSearch_numRows = rsSearch_total; } // set the first and last displayed record rsSearch_first = Math.min(rsSearch_first, rsSearch_total); rsSearch_last = Math.min(rsSearch_first + rsSearch_numRows - 1, rsSearch_total); } %> <% String MM_paramName = ""; %> <% // *** Move To Record and Go To Record: declare variables ResultSet MM_rs = rsSearch; int MM_rsCount = rsSearch_total; int MM_size = rsSearch_numRows; String MM_uniqueCol = ""; MM_paramName = ""; int MM_offset = 0; boolean MM_atTotal = false; boolean MM_paramIsDefined = (MM_paramName.length() != 0 && request.getParameter(MM_paramName) != null); %> <% // *** Move To Record: handle 'index' or 'offset' parameter if (!MM_paramIsDefined && MM_rsCount != 0) { //use index parameter if defined, otherwise use offset parameter String r = request.getParameter("index"); if (r==null) r = request.getParameter("offset"); if (r!=null) MM_offset = Integer.parseInt(r); // if we have a record count, check if we are past the end of the recordset if (MM_rsCount != -1) { if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last if (MM_rsCount % MM_size != 0) // last page not a full repeat region MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } //move the cursor to the selected record int i; for (i=0; rsSearch_hasData && (i < MM_offset || MM_offset == -1); i++) { rsSearch_hasData = MM_rs.next(); } if (!rsSearch_hasData) MM_offset = i; // set MM_offset to the last possible record } %> <% // *** Move To Record: if we dont know the record count, check the display range if (MM_rsCount == -1) { // walk to the end of the display range for this page int i; for (i=MM_offset; rsSearch_hasData && (MM_size < 0 || i < MM_offset + MM_size); i++) { rsSearch_hasData = MM_rs.next(); } // if we walked off the end of the recordset, set MM_rsCount and MM_size if (!rsSearch_hasData) { MM_rsCount = i; if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount; } // if we walked off the end, set the offset based on page size if (!rsSearch_hasData && !MM_paramIsDefined) { if (MM_offset > MM_rsCount - MM_size || MM_offset == -1) { //check if past end or last if (MM_rsCount % MM_size != 0) //last page has less records than MM_size MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } // reset the cursor to the beginning rsSearch.close(); rsSearch = StatementrsSearch.executeQuery(); rsSearch_hasData = rsSearch.next(); MM_rs = rsSearch; // move the cursor to the selected record for (i=0; rsSearch_hasData && i < MM_offset; i++) { rsSearch_hasData = MM_rs.next(); } } %> <% // *** Move To Record: update recordset stats // set the first and last displayed record rsSearch_first = MM_offset + 1; rsSearch_last = MM_offset + MM_size; if (MM_rsCount != -1) { rsSearch_first = Math.min(rsSearch_first, MM_rsCount); rsSearch_last = Math.min(rsSearch_last, MM_rsCount); } // set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount); %> <% // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters String MM_keepBoth,MM_keepURL="",MM_keepForm="",MM_keepNone=""; String[] MM_removeList = { "index", MM_paramName }; // create the MM_keepURL string if (request.getQueryString() != null) { MM_keepURL = '&' + request.getQueryString(); for (int i=0; i < MM_removeList.length && MM_removeList[i].length() != 0; i++) { int start = MM_keepURL.indexOf(MM_removeList[i]) - 1; if (start >= 0 && MM_keepURL.charAt(start) == '&' && MM_keepURL.charAt(start + MM_removeList[i].length() + 1) == '=') { int stop = MM_keepURL.indexOf('&', start + 1); if (stop == -1) stop = MM_keepURL.length(); MM_keepURL = MM_keepURL.substring(0,start) + MM_keepURL.substring(stop); } } } // add the Form variables to the MM_keepForm string if (request.getParameterNames().hasMoreElements()) { java.util.Enumeration items = request.getParameterNames(); while (items.hasMoreElements()) { String nextItem = (String)items.nextElement(); boolean found = false; for (int i=0; !found && i < MM_removeList.length; i++) { if (MM_removeList[i].equals(nextItem)) found = true; } if (!found && MM_keepURL.indexOf('&' + nextItem + '=') == -1) { MM_keepForm = MM_keepForm + '&' + nextItem + '=' + java.net.URLEncoder.encode(request.getParameter(nextItem)); } } } // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length() > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length() > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length() > 0) MM_keepForm = MM_keepForm.substring(1); %> <% // *** Move To Record: set the strings for the first, last, next, and previous links String MM_moveFirst,MM_moveLast,MM_moveNext,MM_movePrev; { String MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves String MM_moveParam = "index="; // if the page has a repeated region, remove 'offset' from the maintained parameters if (MM_size > 1) { MM_moveParam = "offset="; int start = MM_keepMove.indexOf(MM_moveParam); if (start != -1 && (start == 0 || MM_keepMove.charAt(start-1) == '&')) { int stop = MM_keepMove.indexOf('&', start); if (start == 0 && stop != -1) stop++; if (stop == -1) stop = MM_keepMove.length(); if (start > 0) start--; MM_keepMove = MM_keepMove.substring(0,start) + MM_keepMove.substring(stop); } } // set the strings for the move to links StringBuffer urlStr = new StringBuffer(request.getRequestURI()).append('?').append(MM_keepMove); if (MM_keepMove.length() > 0) urlStr.append('&'); urlStr.append(MM_moveParam); MM_moveFirst = urlStr + "0"; MM_moveLast = urlStr + "-1"; MM_moveNext = urlStr + Integer.toString(MM_offset+MM_size); MM_movePrev = urlStr + Integer.toString(Math.max(MM_offset-MM_size,0)); } %> <% int TFM_middlePages,TFM_startLink,TFM_endLink,TFM_LimitPageEndCount; int TFM_LimitCounter,TFM_LimitLinksEndCount,TM_LinksEndCount; %> <% int rsSearch_TFMcurrentPage; int rsSearch_TFMtotalPages; if(MM_size>0) { rsSearch_TFMcurrentPage = (int)Math.ceil((double)rsSearch_last/MM_size); rsSearch_TFMtotalPages = (int)Math.ceil((double)rsSearch_total/MM_size); }else{ rsSearch_TFMcurrentPage = 0; rsSearch_TFMtotalPages = 0; } %> <%=(((rsSearch_data = rsSearch.getObject("xcat3"))==null || rsSearch.wasNull())?"":rsSearch_data)%> » » Snowboard Shop
<%=(((rsSearch_data = rsSearch.getObject( &raquo; &raquo; Snowboard Shop" border="0" >
Use powday.com to find national snowboard & ski resort snow base depth information, a snowboard shop, equipment reviews, plus tricks & how-to's.

Product Groups  

Brands  

thehouse.com  




Recommended Sites

snowboard bindings
snowboard binding
reviews


snowboard goggles

nixon watch shop





more sites...


CloseoutSnowboards
Snowboard Bindings
Snowboard Boots
Find new 2004 styles of snowboard clothing by volcom, ride, burton snowboards & 686 online here at powday.com

<%if (rsSearch__g != "%") {%> <%} //end if %> <%if (rsSearch__b != "%") {%> <%} //end if %>

<%=(((rsSearch_data = rsSearch.getObject("xcat3"))==null || rsSearch.wasNull())?"":rsSearch_data)%>

» » <%=(((rsSearch_data = rsSearch.getObject("xcat4"))==null || rsSearch.wasNull())?"":rsSearch_data)%>

» » <%=(((rsSearch_data = rsSearch.getObject("manufacturer"))==null || rsSearch.wasNull())?"":rsSearch_data)%>

<% currCategory = "nothingequalsthis"; %> <% if(!rsSearch_hasData){ %> [ no listing ] <% } //end if %> <% while ((rsSearch_hasData)&&(Repeat1__numRows-- != 0)) { %> <% if(false) { %> <%// if(!(((rsSearch_data = rsSearch.getObject("category"))==null || rsSearch.wasNull())?"":rsSearch_data).equals(currCategory)) { %> <% fourCount = 0; %> <% } //end if %> <% if(fourCount == 3) { %> <% fourCount = 0; %> <% } //end if %> <% currCategory = rsSearch.getObject("xcat3"); %> <% Repeat1__index++; fourCount++; rsSearch_hasData = rsSearch.next(); }%>

<% /* if( !(((rsListPriceRange_data = rsListPriceRange.getObject("pricepoint1"))==null || rsListPriceRange.wasNull())?"":rsListPriceRange_data).equals( (((rsListPriceRange_data = rsListPriceRange.getObject("pricepoint2"))==null || rsListPriceRange.wasNull())?"":rsListPriceRange_data)) && rsListPriceRange.getObject("pricepoint1")!=null ) {out.println("they are not equal");} */ %>

  
">" border="0">
<%=(((rsSearch_data = rsSearch.getObject("name"))==null || rsSearch.wasNull())?"":rsSearch_data)%>
$<%=(((rsSearch_data = rsSearch.getObject("price"))==null || rsSearch.wasNull())?"":rsSearch_data)%>
<%//="fourCount is "+ fourCount %>  
<% TFM_middlePages = 7; if(MM_offset != 0 || rsSearch_TFMtotalPages != 0) { if(rsSearch_TFMcurrentPage > 1) { out.print(""); }else{ out.print(""); } if(rsSearch_TFMtotalPages != 1) {out.print("page ");} } %> <% if(MM_offset != 0) { if(rsSearch_TFMcurrentPage > TFM_middlePages/2+1) { out.print("1 "); } if(rsSearch_TFMcurrentPage > TFM_middlePages/2+2) { out.print("..."); } }else{ out.print(""); } //out.print("|"); %> <% if(rsSearch_TFMtotalPages != 1) { TFM_startLink = MM_offset/MM_size - (int)((double)(TFM_middlePages/2 + .5)); TFM_endLink = MM_offset/MM_size + (int)((double)(TFM_middlePages/2 + .5)); if (TFM_middlePages/2 != (int)((double)TFM_middlePages/2 + .5)) TFM_endLink = TFM_endLink + 1; if (TFM_startLink < 0) { TFM_startLink = 0; TFM_endLink = TFM_middlePages; } TFM_LimitCounter = 0; for (int i=1; i <= rsSearch_total;i = i+MM_size) { TFM_LimitCounter = TFM_LimitCounter + 1; TFM_LimitPageEndCount = i + MM_size - 1; if (TFM_LimitPageEndCount > rsSearch_total) { TFM_LimitPageEndCount = rsSearch_total; } if ((TFM_LimitCounter > TFM_startLink) && (TFM_LimitCounter <= TFM_endLink)) { if (i != MM_offset + 1) { out.print("'); out.print(TFM_LimitCounter + ""); }else{ out.print("" + TFM_LimitCounter + ""); } if((TFM_LimitPageEndCount != rsSearch_total) && ((int)(TFM_endLink) != TFM_LimitCounter)) out.print(" "); } } } %> <% //out.print("|"); if(rsSearch_TFMtotalPages > TFM_middlePages - 1 || MM_offset != 0) { if(rsSearch_TFMtotalPages - rsSearch_TFMcurrentPage > 4 ) { out.print("..."); } if(rsSearch_TFMtotalPages - rsSearch_TFMcurrentPage > 3 ) { out.print(" " + rsSearch_TFMtotalPages + ""); } }else{ out.print(""); } out.print(" "); if(!MM_atTotal) { out.print(" "); }else{ out.print(" "); } %>

Current Time  


Snowboard Shop
» Home

Alphabetical Site Map
» Alpine Skis
» Alpine Touring
» Avalanche Safety
» Backpacks
» Car Racks
» Cross Country
» Goggles
» Headlamps
» Helmets
» Kids Clothing
» Men's Footwear
» Men's Snowboard Clothing
» Men's Sportswear
» Men's Winter Clothing
» Navigation
» Ski
» Ski Accessory
» Ski Bindings
» Ski Boots
» Ski Clothing
» Ski Goggles
» Ski Helmets
» Ski Tune Up Kits
» Snowboard
» Snowboard Accessory
» Snowboard Bindings
» Snowboard Boots
» Snowboard Clothing
» Snowboard Goggles
» Snowboard Helmets
» Snowboard Tune Up Kits
» Snowshoes
» Sunglasses
» Telemark Skiing
» Watches
» Winter Accessories
» Women's Footwear
» Women's Sportswear
» Women's Winter Clothing

Save at USOUTDOOR.com  

snowboard shop

Didn't find what you were looking for?

Try going back to the home page to start your search: powday.com


Read more...  comments?

SNOWBOARD BINDING REVIEWS

We found snowboard-bindings.net while browsing around the web looking for snowboard binding reviews. They feature close out snowboards and equipment. This snowboard shop also offers free shipping and no sales tax on all orders over $40.00 shipped in the contiguous usa.

An excellent site and really easy top navigate, with lots of useful and fun information!

Follow the link below to visit this great site!

http://www.snowboard-bindings.net


Read more...  comments?

REEF SANDALS

Reef Sandals - Shop the largest selection of reef sandals available online.

Follow the link below to visit this great site!

http://www.usoutdoorstore.com/reef-sandals.htm


Read more...  comments?






<% rsSearch.close(); StatementrsSearch.close(); ConnrsSearch.close(); %> <% rsListSub.close(); StatementrsListSub.close(); ConnrsListSub.close(); %> <% rsCategoryBrand.close(); StatementrsCategoryBrand.close(); ConnrsCategoryBrand.close(); %>