Martini List
<% If Not rsMartinis.EOF Or Not rsMartinis.BOF Then %>| <%=(rsMartinis.Fields.Item("MartiniName").Value)%> | <%=(rsMartinis.Fields.Item("description").Value)%> |
* Items subject to change
%@LANGUAGE="VBSCRIPT"%> <% Dim rsMartinis Dim rsMartinis_numRows Set rsMartinis = Server.CreateObject("ADODB.Recordset") rsMartinis.ActiveConnection = MM_Steamers_STRING rsMartinis.Source = "SELECT M.ID, M.categoryID, M.name as MartiniName, M.description, M.displayOrder, M.active, C.ID, C.name as CategoryName, C.displayOrder, C.active FROM tblDrinks as M INNER JOIN tblDrinkCategories as C ON M.categoryID = C.ID WHERE M.active <> 0 AND C.active<> 0 ORDER BY c.displayOrder ASC, M.displayOrder ASC" rsMartinis.CursorType = 0 rsMartinis.CursorLocation = 2 rsMartinis.LockType = 1 rsMartinis.Open() rsMartinis_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rsMartinis_numRows = rsMartinis_numRows + Repeat1__numRows %>
| <%=(rsMartinis.Fields.Item("MartiniName").Value)%> | <%=(rsMartinis.Fields.Item("description").Value)%> |
* Items subject to change
