%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "6" If (Request("MM_EmptyValue") <> "") Then Recordset1__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset1 Dim Recordset1_cmd Dim Recordset1_numRows Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1_cmd.ActiveConnection = MM_ConnStMary_STRING Recordset1_cmd.CommandText = "SELECT * FROM MinistriesandActivities WHERE xID = ?" Recordset1_cmd.Prepared = true Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam) ' adDouble Set Recordset1 = Recordset1_cmd.Execute Recordset1_numRows = 0 %> <% Dim Recordset2 Dim Recordset2_cmd Dim Recordset2_numRows Set Recordset2_cmd = Server.CreateObject ("ADODB.Command") Recordset2_cmd.ActiveConnection = MM_ConnStMary_STRING Recordset2_cmd.CommandText = "SELECT * FROM [1SubLink]" Recordset2_cmd.Prepared = true Set Recordset2 = Recordset2_cmd.Execute Recordset2_numRows = 0 %> <% Dim Recordset3 Dim Recordset3_cmd Dim Recordset3_numRows Set Recordset3_cmd = Server.CreateObject ("ADODB.Command") Recordset3_cmd.ActiveConnection = MM_ConnStMary_STRING Recordset3_cmd.CommandText = "SELECT * FROM MainLinks" Recordset3_cmd.Prepared = true Set Recordset3 = Recordset3_cmd.Execute Recordset3_numRows = 0 %> <% Dim Recordset4__MMColParam Recordset4__MMColParam = "2" If (Request("MM_EmptyValue") <> "") Then Recordset4__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset4 Dim Recordset4_cmd Dim Recordset4_numRows Set Recordset4_cmd = Server.CreateObject ("ADODB.Command") Recordset4_cmd.ActiveConnection = MM_ConnStMary_STRING Recordset4_cmd.CommandText = "SELECT * FROM MainLinks WHERE xID = ?" Recordset4_cmd.Prepared = true Recordset4_cmd.Parameters.Append Recordset4_cmd.CreateParameter("param1", 5, 1, -1, Recordset4__MMColParam) ' adDouble Set Recordset4 = Recordset4_cmd.Execute Recordset4_numRows = 0 %> <% Dim Recordset5__MMColParam Recordset5__MMColParam = "3" If (Request("MM_EmptyValue") <> "") Then Recordset5__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset5 Dim Recordset5_cmd Dim Recordset5_numRows Set Recordset5_cmd = Server.CreateObject ("ADODB.Command") Recordset5_cmd.ActiveConnection = MM_ConnStMary_STRING Recordset5_cmd.CommandText = "SELECT * FROM MainLinks WHERE xID = ?" Recordset5_cmd.Prepared = true Recordset5_cmd.Parameters.Append Recordset5_cmd.CreateParameter("param1", 5, 1, -1, Recordset5__MMColParam) ' adDouble Set Recordset5 = Recordset5_cmd.Execute Recordset5_numRows = 0 %> <% Dim Recordset6__MMColParam Recordset6__MMColParam = "4" If (Request("MM_EmptyValue") <> "") Then Recordset6__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset6 Dim Recordset6_cmd Dim Recordset6_numRows Set Recordset6_cmd = Server.CreateObject ("ADODB.Command") Recordset6_cmd.ActiveConnection = MM_ConnStMary_STRING Recordset6_cmd.CommandText = "SELECT * FROM MainLinks WHERE xID = ?" Recordset6_cmd.Prepared = true Recordset6_cmd.Parameters.Append Recordset6_cmd.CreateParameter("param1", 5, 1, -1, Recordset6__MMColParam) ' adDouble Set Recordset6 = Recordset6_cmd.Execute Recordset6_numRows = 0 %> <% Dim Recordset7__MMColParam Recordset7__MMColParam = "5" If (Request("MM_EmptyValue") <> "") Then Recordset7__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset7 Dim Recordset7_numRows Set Recordset7 = Server.CreateObject("ADODB.Recordset") Recordset7.ActiveConnection = MM_ConnectionStMarys_STRING Recordset7.Source = "SELECT * FROM MainLinks WHERE xID = " + Replace(Recordset7__MMColParam, "'", "''") + "" Recordset7.CursorType = 0 Recordset7.CursorLocation = 2 Recordset7.LockType = 1 Recordset7.Open() Recordset7_numRows = 0 %> <% Dim Recordset8__MMColParam Recordset8__MMColParam = "6" If (Request("MM_EmptyValue") <> "") Then Recordset8__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset8 Dim Recordset8_numRows Set Recordset8 = Server.CreateObject("ADODB.Recordset") Recordset8.ActiveConnection = MM_ConnectionStMarys_STRING Recordset8.Source = "SELECT * FROM MainLinks WHERE xID = " + Replace(Recordset8__MMColParam, "'", "''") + "" Recordset8.CursorType = 0 Recordset8.CursorLocation = 2 Recordset8.LockType = 1 Recordset8.Open() Recordset8_numRows = 0 %> <% Dim Recordset9__MMColParam Recordset9__MMColParam = "7" If (Request("MM_EmptyValue") <> "") Then Recordset9__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset9 Dim Recordset9_numRows Set Recordset9 = Server.CreateObject("ADODB.Recordset") Recordset9.ActiveConnection = MM_ConnectionStMarys_STRING Recordset9.Source = "SELECT * FROM MainLinks WHERE xID = " + Replace(Recordset9__MMColParam, "'", "''") + "" Recordset9.CursorType = 0 Recordset9.CursorLocation = 2 Recordset9.LockType = 1 Recordset9.Open() Recordset9_numRows = 0 %> <% Dim Recordset10__MMColParam Recordset10__MMColParam = "8" If (Request("MM_EmptyValue") <> "") Then Recordset10__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset10 Dim Recordset10_numRows Set Recordset10 = Server.CreateObject("ADODB.Recordset") Recordset10.ActiveConnection = MM_ConnectionStMarys_STRING Recordset10.Source = "SELECT * FROM MainLinks WHERE xID = " + Replace(Recordset10__MMColParam, "'", "''") + "" Recordset10.CursorType = 0 Recordset10.CursorLocation = 2 Recordset10.LockType = 1 Recordset10.Open() Recordset10_numRows = 0 %> <% Dim Recordset11__MMColParam Recordset11__MMColParam = "9" If (Request("MM_EmptyValue") <> "") Then Recordset11__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset11 Dim Recordset11_numRows Set Recordset11 = Server.CreateObject("ADODB.Recordset") Recordset11.ActiveConnection = MM_ConnectionStMarys_STRING Recordset11.Source = "SELECT * FROM MainLinks WHERE xID = " + Replace(Recordset11__MMColParam, "'", "''") + "" Recordset11.CursorType = 0 Recordset11.CursorLocation = 2 Recordset11.LockType = 1 Recordset11.Open() Recordset11_numRows = 0 %> <% Dim Recordset12__MMColParam Recordset12__MMColParam = "10" If (Request("MM_EmptyValue") <> "") Then Recordset12__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset12 Dim Recordset12_numRows Set Recordset12 = Server.CreateObject("ADODB.Recordset") Recordset12.ActiveConnection = MM_ConnectionStMarys_STRING Recordset12.Source = "SELECT * FROM MainLinks WHERE xID = " + Replace(Recordset12__MMColParam, "'", "''") + "" Recordset12.CursorType = 0 Recordset12.CursorLocation = 2 Recordset12.LockType = 1 Recordset12.Open() Recordset12_numRows = 0 %> <% Dim RsBulletin__MMColParam RsBulletin__MMColParam = "11" If (Request("MM_EmptyValue") <> "") Then RsBulletin__MMColParam = Request("MM_EmptyValue") End If %> <% Dim RsBulletin Dim RsBulletin_cmd Dim RsBulletin_numRows Set RsBulletin_cmd = Server.CreateObject ("ADODB.Command") RsBulletin_cmd.ActiveConnection = MM_ConnStMary_STRING RsBulletin_cmd.CommandText = "SELECT * FROM MainLinks WHERE xID = ?" RsBulletin_cmd.Prepared = true RsBulletin_cmd.Parameters.Append RsBulletin_cmd.CreateParameter("param1", 5, 1, -1, RsBulletin__MMColParam) ' adDouble Set RsBulletin = RsBulletin_cmd.Execute RsBulletin_numRows = 0 %>
<%=(Recordset1.Fields.Item("xBody").Value)%>