%@LANGUAGE="VBSCRIPT"%> <% Dim rsGifts__MMColParam rsGifts__MMColParam = "0" if (Request("MM_EmptyValue") <> "") then rsGifts__MMColParam = Request("MM_EmptyValue") %> <% set rsGifts = Server.CreateObject("ADODB.Recordset") rsGifts.ActiveConnection = MM_CoffeeWorld_STRING rsGifts.Source = "SELECT ProductID, ProductName, ProductDescription, PricePerUnit, PrimaryUnit, Unit FROM jmurray.PRODUCTS WHERE isBean = " + Replace(rsGifts__MMColParam, "'", "''") + " ORDER BY ProductName ASC" rsGifts.CursorType = 0 rsGifts.CursorLocation = 2 rsGifts.LockType = 3 rsGifts.Open() rsGifts_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 rsGifts_numRows = rsGifts_numRows + Repeat1__numRows %>
|
|||||||||||||