%@LANGUAGE="VBSCRIPT"%> <% Dim rsMenu__MMColParam rsMenu__MMColParam = "1" if (Request("MM_EmptyValue") <> "") then rsMenu__MMColParam = Request("MM_EmptyValue") %> <% set rsMenu = Server.CreateObject("ADODB.Recordset") rsMenu.ActiveConnection = MM_ConnMixData_STRING rsMenu.Source = "SELECT * FROM MenuItems WHERE MenuStore = " + Replace(rsMenu__MMColParam, "'", "''") + " AND MenuLevel = 0 ORDER BY MenuName" rsMenu.CursorType = 0 rsMenu.CursorLocation = 2 rsMenu.LockType = 3 rsMenu.Open() rsMenu_numRows = 0 %> <% set rsAds = Server.CreateObject("ADODB.Recordset") rsAds.ActiveConnection = MM_ConnMixData_STRING rsAds.Source = "SELECT * FROM Advertising WHERE left(Ad_Tie_String,1) = 'v'" rsAds.CursorType = 0 rsAds.CursorLocation = 2 rsAds.LockType = 3 rsAds.Open() rsAds_numRows = 0 %> <% set rsAdsH = Server.CreateObject("ADODB.Recordset") rsAdsH.ActiveConnection = MM_ConnMixData_STRING rsAdsH.Source = "SELECT * FROM Advertising WHERE left(Ad_Tie_String,1) = 'h'" rsAdsH.CursorType = 0 rsAdsH.CursorLocation = 2 rsAdsH.LockType = 3 rsAdsH.Open() rsAdsH_numRows = 0 %>
![]() |
<%
rsAdsh.MoveFirst
AdTotal=0
Randomize
While Not rsAdsh.EOF
AdTotal= AdTotal+1
rsAdsh.MoveNext
Wend
Selection = Int(AdTotal*Rnd)
rsAdsh.MoveFirst
While Not rsAdsh.EOF and MoveTo
|
||||
|
Beer
and Wine Festival Search Page
Find a festival in your area |
|||||
|
<%IF PageID = 1 Then%>
|
Food and Wine Festivals: Find the Beer Festival or Wine Festival Coming To a Town Near You!What’s greater than food and wine festivals near you? Eat, drink and be quite merry with our list of beer festivals coming soon to your town. Choose the food and wine festivals you want to attend and enjoy new flavors of food and drink! Broaden your horizons while enjoying the good company at wine festivals. Wine festivals give you a great opportunity to taste new or unusual wines you might not have experienced otherwise. Of course, the atmosphere at a wine festival can’t be beat. Where else are you surrounded with individuals who appreciate the taste of wine like you? Get more information about upcoming beer festivals now.
You love the drink, entertainment and atmosphere of one of the many beer
festivals. Check out a beer festival near you today. If you know of any festivals that you would like to add, click on the add button on the next page. Please keep in mind that they must have a drink related theme for us to add them to our database. We will then review the information for validity and accuracy and add it to our list. |
<%dim Insert_name(30), Insert_URL(30), Insert_Text(30), Insert_Priority(30)
Insert_name(1)= "bbn.jpg"
Insert_URL(1)= "http://www.mixologys.com/xq/cat0000.asp"
Insert_Text(1)= ""
rsAds.MoveFirst
Count_Found=0
While Not rsAds.EOF
countdown=count
while countdown>0%>
<%Found=Instr(LCase(rsAds.Fields.Item("Ad_tie_string").value),LCase(ingred(countdown)))
If Found > 0 Then
Count_Found=Count_Found +1
Insert_name(Count_Found)= (rsAds.Fields.Item("Ad_File_Name").Value)
Insert_URL(Count_Found)= (rsAds.Fields.Item("Ad_URL").Value)
Insert_Text(Count_Found)= (rsAds.Fields.Item("Ad_Text").Value)
Insert_Priority(Count_Found)= (rsAds.Fields.Item("Ad_Priority").Value)
End If
countdown=countdown-1
wend
rsAds.MoveNext
Wend
Randomize
Selection = Int(Count_Found*Rnd)+1%>
|
|||
|
Credits
|
|||||
<% rsAds.Close() Set rsAds = Nothing %> <% rsStates.Close() Set rsStates = Nothing %>