%@LANGUAGE="VBSCRIPT"%> <% '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' Spd E-Letter v4 ' © 2001, 2002 PensaWorks, inc. ' For help with this program, please visit http://www.pensaworks.com '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim Access : Access = "User" Dim Nav3 : Nav3 = "2" %> <% onNum = 0 if (request("msg") <> "") then msg = request("msg") if (request("sn") <> "") then sn = request("sn") else sn = "blkID" if (request("so") <> "") then so = request("so") else so = "asc" if (IsNumeric(viewNumSub)) then NR = ViewNumSub else NR = 20 if (request("pg") <> "") then pg = CInt(request("pg")) else pg = 1 set getRecords = mlConn.Execute("SELECT * FROM ML_Blocked WHERE blkType = 0 ORDER BY " & sn & " " & so) set recCount = mlConn.Execute("SELECT COUNT(*) AS cnt1 FROM ML_Blocked") if getRecords.EOF then totalRecords = 0 totalPages = 1 else totalRecords = recCount("cnt1") : set recCount = nothing totalPages = Int(totalRecords / NR) if totalRecords mod NR > 0 then totalPages = totalPages + 1 if PG > 2 then moveRecs = NR * (PG - 1) else moveRecs = 0 if (PG > 1) AND (moveRecs <= totalRecords) then moveRecs = (NR * (PG - 1)) else moveRecs = 0 end if getRecords.Move moveRecs end if %>