%@LANGUAGE="VBSCRIPT"%> <% set data = Server.CreateObject("ADODB.Recordset") data.ActiveConnection = MM_just8ns_STRING data.Source = "SELECT * FROM inventory WHERE ProductType = 'governor'" data.CursorType = 0 data.CursorLocation = 2 data.LockType = 3 data.Open() data_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 data_numRows = data_numRows + Repeat1__numRows %>
Governor
and Related Parts
|
||||||||
| Product ID | Description | Years | Price | Quantity | Order | |||
| <%=(data.Fields.Item("ProductId").Value)%> | <%=(data.Fields.Item("Description").Value)%> | <%=(data.Fields.Item("Years").Value)%> | <%= FormatCurrency((data.Fields.Item("Retail").Value), 2, -2, -2, -2) %> | <% IF data.Fields.Item("Quantity").Value > 0 THEN %><%=(data.Fields.Item("Quantity").Value)%><% ELSEIF data.Fields.Item("Quantity").Value = 0 THEN %>Out of Stock<% ELSE %>coming Soon<% END IF %> | ||||
|
|
||||||||