<%@ Language="JScript"%> <% /***** GLOBAL VARS *****/ var _paypal_shipping = "5.65"; /***** END OF GLOBAL VARS *****/ /***** DB GLOBAL STUFF *****/ var _cn; _cn = Server.CreateObject("ADODB.Connection"); strcn = "driver={MySQL ODBC 3.51 Driver};option=4;server=mysql41.secureserver.net;user=bjakedbuser;password=samson8;DATABASE=bjakedbuser;"; _cn.Open(strcn,"",""); /***** END OF DB GLOBAL STUFF *****/ %> <% var _sqlStr = "SELECT * FROM tbl_store_regions ORDER BY sr_sort_order;"; var _rsRegions = Server.CreateObject("ADODB.RecordSet"); _rsRegions.Open(_sqlStr, _cn, 3, 3); %> Barbecue sauce, barbecue ribs, barbecue chicken, barbecue shrimp, steak sauce, hot sauce
 
<% while(!(_rsRegions.Eof)) { var _sqlStr = "SELECT DISTINCT sl_subreg_name FROM tbl_store_locations WHERE sl_reg_id = "+ parseInt(_rsRegions("sr_id")) +";"; var _rsSubRegions = Server.CreateObject("ADODB.RecordSet"); _rsSubRegions.Open(_sqlStr, _cn, 3, 3); %>
  <%=_rsRegions("sr_name")%>  
<% while(!(_rsSubRegions.Eof)) { if(String(_rsSubRegions("sl_subreg_name")) == "" || String(_rsSubRegions("sl_subreg_name")) == "null" ) { var _subRegionHeading = ""; var _subRegionDB = "ISNULL(sl_subreg_name)"; } else { var _subRegionHeading = _rsSubRegions("sl_subreg_name") + "
"; var _subRegionDB = "sl_subreg_name = '"+ _rsSubRegions("sl_subreg_name") +"'"; } var _sqlStr_Loc = "SELECT * FROM tbl_store_locations WHERE sl_reg_id = "+ parseInt(_rsRegions("sr_id")) +" AND "+ _subRegionDB +";"; var _rsLocations = Server.CreateObject("ADODB.RecordSet"); _rsLocations.Open(_sqlStr_Loc, _cn, 3, 3); %>
<%=_subRegionHeading%> <% while(!(_rsLocations.Eof)) { var weblink = ""; var maplink = ""; var printlink = ""; if(parseInt(_rsLocations("sl_showmethod")) == 1) { weblink = "  "; printlink = weblink; } if(parseInt(_rsLocations("sl_showmethod")) == 2) { if(_rsLocations("sl_country") == "USA") var cntry = "US"; else if(_rsLocations("sl_country") == "CANADA") var cntry = "CA"; else var cntry = ""; maplink = "  "; printlink = maplink; } if(parseInt(_rsLocations("sl_showmethod")) == 3) { weblink = ""; maplink = ""; printlink = weblink + maplink; } %> <%=_rsLocations("sl_name")%>  <%=printlink%>
<% _rsLocations.MoveNext(); } _rsSubRegions.MoveNext(); %>
<% } %>
<% _rsRegions.MoveNext(); } %>

Special Orders   |  Our Sauces   |  How to Order  |  Locate
Copyright 2004 - Jake's Smokehouse Style BBQ Sauce
<% _rsRegions.Close(); %> <% _cn.Close(); %>