<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*, java.util.regex.*, java.util.Random, java.util.Map, java.util.LinkedHashMap" errorPage="" %><%@ include file="/Connections/bidango.htm" %><%@ include file="/Connections/snowReport.jsp" %><% String search = "%"; if (request.getParameter("search") !=null) {search = (String)request.getParameter("search") ;} if (request.getParameter("search2") !=null) {search = (String)request.getParameter("search2") ;} String cat_ = "%"; String cat = "%"; if (request.getParameter("cat_") !=null) {cat_ = (String)request.getParameter("cat_") ;} %><% String lookFor = "(.*)_(.*)"; //regex String replaceWith = "$1 $2"; //replacement cat = Pattern.compile(lookFor).matcher(cat_).replaceAll(replaceWith); %><% String sort = "name"; 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 name,imageurl,programname,price,xcat4,thumburl,description,retailprice FROM products WHERE MATCH(name,manufacturer,keywords,advertisercategory) AGAINST('" + search + "') LIMIT 50"); 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; %><% int Repeat1__numRows = 12; int Repeat1__index = 0; rsSearch_numRows += Repeat1__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; } %><% Driver Driverrs24hrSnow = (Driver)Class.forName(MM_snowReport_DRIVER).newInstance(); Connection Connrs24hrSnow = DriverManager.getConnection(MM_snowReport_STRING,MM_snowReport_USERNAME,MM_snowReport_PASSWORD); PreparedStatement Statementrs24hrSnow = Connrs24hrSnow.prepareStatement("SELECT * FROM snow_report.SnowStats where past24hr <> '0' order by past24hr DESC "); ResultSet rs24hrSnow = Statementrs24hrSnow.executeQuery(); boolean rs24hrSnow_isEmpty = !rs24hrSnow.next(); boolean rs24hrSnow_hasData = !rs24hrSnow_isEmpty; Object rs24hrSnow_data; int rs24hrSnow_numRows = 0; %><% int Repeat2__numRows = 20; int Repeat2__index = 0; rs24hrSnow_numRows += Repeat2__numRows; %> <%=(((rsSearch_data = rsSearch.getObject("xcat4"))==null || rsSearch.wasNull())?"":rsSearch_data)%> » » Snowboard Shop
This old school deluxe snowboard shop has it all, clearance deals, burton  K2 The North Face ride salomon drake read reviews on northwave forum sessions and compare prices on oakley dakine spy defcon pro tec and more from the web's top online sports stores
Use powday.com to find national snowboard & ski resort snow base depth information, a snowboard shop, equipment reviews, plus tricks & how-to's.
Snowboard Shop
Men's Women's
Current Time  

» Home

CLOTHING SHOPS:
» Men's Clothing
» Women's Clothing
» Kid's Clothing
» Footwear
» Watches
» Sunglasses
» Snow Goggles

GEAR SHOPS:
» Snowboard Shop
» Ski Shop
» Backpacks


INFORMATION

We've just added new catagories, a snowboard shop list and ski resort information.

Find a snowboard shop here
We let you compare prices between top online ski and snowboard shops

Featured Brands  

thehouse.com  




.

snowboard shop sponsors:
the backcountry store
the house
boardtactics
usoutdoor.com
rei.com


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

YOUR SEARCH RESULTS FOR <% out.print(search); %>

<% 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("xcat4"); %> <% 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");} */ %>

   
~~<%=(((rsSearch_data = rsSearch.getObject("name"))==null || rsSearch.wasNull())?"":rsSearch_data)%>.html">" width="100" border="0">
<%=(((rsSearch_data = rsSearch.getObject("name"))==null || rsSearch.wasNull())?"":rsSearch_data)%>
@ <%=(((rsSearch_data = rsSearch.getObject("programname"))==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(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(" "); } %>

STILL LOOKING?

Try starting back at our homepage: 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?


Save at USOUTDOOR.com  





Unbelievable gear and the place to find the latest news on where the powders at plus new burton snowboards, ride bindings, oakley goggles, dakine snowboard bags, salomon boots, 686 clothing, dragon optics, defcon gloves, snowboard helmets and accessories here. snowboard shop <% rs24hrSnow.close(); Statementrs24hrSnow.close(); Connrs24hrSnow.close(); %><% rsSearch.close(); StatementrsSearch.close(); ConnrsSearch.close(); %>