%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% on error resume next %> [an error occurred while processing this directive] [an error occurred while processing this directive] <% Dim MantleAdsRS Dim MantleAdsRS_numRows Set MantleAdsRS = Server.CreateObject("ADODB.Recordset") MantleAdsRS.ActiveConnection = MM_cessnaflyer_STRING MantleAdsRS.Source = "SELECT * FROM MantleAdsDB ORDER BY SortOrder ASC" MantleAdsRS.CursorType = 0 MantleAdsRS.CursorLocation = 2 MantleAdsRS.LockType = 1 MantleAdsRS.Open() MantleAdsRS_numRows = 0 %> <% Dim MemberInfo__MMColParam MemberInfo__MMColParam = "1" If (Session("MM_Username") <> "") Then MemberInfo__MMColParam = Session("MM_Username") End If %> <% Dim MemberInfo Dim MemberInfo_numRows Set MemberInfo = Server.CreateObject("ADODB.Recordset") MemberInfo.ActiveConnection = MM_cessnaflyer_STRING MemberInfo.Source = "SELECT * FROM MemberDB WHERE EmailAddress = '" + Replace(MemberInfo__MMColParam, "'", "''") + "'" MemberInfo.CursorType = 0 MemberInfo.CursorLocation = 2 MemberInfo.LockType = 1 MemberInfo.Open() MemberInfo_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 MantleAdsRS_numRows = MantleAdsRS_numRows + Repeat1__numRows %>
|
||||||||||||||||||
|
||||||||||||||||||