<%@LANGUAGE="JAVASCRIPT"%> <% var rsA__MMColParam = "A"; if(String(Request("MM_EmptyValue")) != "undefined") { rsA__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsA = Server.CreateObject("ADODB.Recordset"); rsA.ActiveConnection = MM_strDSN_STRING; rsA.Source = "SELECT * FROM rate WHERE type = '"+ rsA__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsA.CursorType = 0; rsA.CursorLocation = 2; rsA.LockType = 3; rsA.Open(); var rsA_numRows = 0; %> <% var rsB__MMColParam = "B"; if(String(Request("MM_EmptyValue")) != "undefined") { rsB__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsB = Server.CreateObject("ADODB.Recordset"); rsB.ActiveConnection = MM_strDSN_STRING; rsB.Source = "SELECT * FROM rate WHERE type = '"+ rsB__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsB.CursorType = 0; rsB.CursorLocation = 2; rsB.LockType = 3; rsB.Open(); var rsB_numRows = 0; %> <% var rsC__MMColParam = "C"; if(String(Request("MM_EmptyValue")) != "undefined") { rsC__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsC = Server.CreateObject("ADODB.Recordset"); rsC.ActiveConnection = MM_strDSN_STRING; rsC.Source = "SELECT * FROM rate WHERE type = '"+ rsC__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsC.CursorType = 0; rsC.CursorLocation = 2; rsC.LockType = 3; rsC.Open(); var rsC_numRows = 0; %> <% var rsD__MMColParam = "D"; if(String(Request("MM_EmptyValue")) != "undefined") { rsD__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsD = Server.CreateObject("ADODB.Recordset"); rsD.ActiveConnection = MM_strDSN_STRING; rsD.Source = "SELECT * FROM rate WHERE type = '"+ rsD__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsD.CursorType = 0; rsD.CursorLocation = 2; rsD.LockType = 3; rsD.Open(); var rsD_numRows = 0; %> <% var rsE__MMColParam = "E"; if(String(Request("MM_EmptyValue")) != "undefined") { rsE__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsE = Server.CreateObject("ADODB.Recordset"); rsE.ActiveConnection = MM_strDSN_STRING; rsE.Source = "SELECT * FROM rate WHERE type = '"+ rsE__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsE.CursorType = 0; rsE.CursorLocation = 2; rsE.LockType = 3; rsE.Open(); var rsE_numRows = 0; %> <% var rsF__MMColParam = "F"; if(String(Request("MM_EmptyValue")) != "undefined") { rsF__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsF = Server.CreateObject("ADODB.Recordset"); rsF.ActiveConnection = MM_strDSN_STRING; rsF.Source = "SELECT * FROM rate WHERE type = '"+ rsF__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsF.CursorType = 0; rsF.CursorLocation = 2; rsF.LockType = 3; rsF.Open(); var rsF_numRows = 0; %> <% var rsG__MMColParam = "G"; if(String(Request("MM_EmptyValue")) != "undefined") { rsG__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsG = Server.CreateObject("ADODB.Recordset"); rsG.ActiveConnection = MM_strDSN_STRING; rsG.Source = "SELECT * FROM rate WHERE type = '"+ rsG__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsG.CursorType = 0; rsG.CursorLocation = 2; rsG.LockType = 3; rsG.Open(); var rsG_numRows = 0; %> <% var rsH__MMColParam = "H"; if(String(Request("MM_EmptyValue")) != "undefined") { rsH__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsH = Server.CreateObject("ADODB.Recordset"); rsH.ActiveConnection = MM_strDSN_STRING; rsH.Source = "SELECT * FROM rate WHERE type = '"+ rsH__MMColParam.replace(/'/g, "''") + "' ORDER BY ID ASC"; rsH.CursorType = 0; rsH.CursorLocation = 2; rsH.LockType = 3; rsH.Open(); var rsH_numRows = 0; %> <% var rsCommA = Server.CreateObject("ADODB.Recordset"); rsCommA.ActiveConnection = MM_strDSN_STRING; rsCommA.Source = "SELECT * FROM comments WHERE TYPE = 'A'"; rsCommA.CursorType = 0; rsCommA.CursorLocation = 2; rsCommA.LockType = 3; rsCommA.Open(); var rsCommA_numRows = 0; %> <% var rsCommB = Server.CreateObject("ADODB.Recordset"); rsCommB.ActiveConnection = MM_strDSN_STRING; rsCommB.Source = "SELECT * FROM comments WHERE TYPE = 'B'"; rsCommB.CursorType = 0; rsCommB.CursorLocation = 2; rsCommB.LockType = 3; rsCommB.Open(); var rsCommB_numRows = 0; %> <% var rsCommC = Server.CreateObject("ADODB.Recordset"); rsCommC.ActiveConnection = MM_strDSN_STRING; rsCommC.Source = "SELECT * FROM comments WHERE TYPE = 'C'"; rsCommC.CursorType = 0; rsCommC.CursorLocation = 2; rsCommC.LockType = 3; rsCommC.Open(); var rsCommC_numRows = 0; %> <% var rsCommD = Server.CreateObject("ADODB.Recordset"); rsCommD.ActiveConnection = MM_strDSN_STRING; rsCommD.Source = "SELECT * FROM comments WHERE TYPE = 'D'"; rsCommD.CursorType = 0; rsCommD.CursorLocation = 2; rsCommD.LockType = 3; rsCommD.Open(); var rsCommD_numRows = 0; %> <% var rsCommE = Server.CreateObject("ADODB.Recordset"); rsCommE.ActiveConnection = MM_strDSN_STRING; rsCommE.Source = "SELECT * FROM comments WHERE TYPE = 'E'"; rsCommE.CursorType = 0; rsCommE.CursorLocation = 2; rsCommE.LockType = 3; rsCommE.Open(); var rsCommE_numRows = 0; %> <% var rsCommF = Server.CreateObject("ADODB.Recordset"); rsCommF.ActiveConnection = MM_strDSN_STRING; rsCommF.Source = "SELECT * FROM comments WHERE TYPE = 'F'"; rsCommF.CursorType = 0; rsCommF.CursorLocation = 2; rsCommF.LockType = 3; rsCommF.Open(); var rsCommF_numRows = 0; %> <% var rsCommG = Server.CreateObject("ADODB.Recordset"); rsCommG.ActiveConnection = MM_strDSN_STRING; rsCommG.Source = "SELECT * FROM comments WHERE TYPE = 'G'"; rsCommG.CursorType = 0; rsCommG.CursorLocation = 2; rsCommG.LockType = 3; rsCommG.Open(); var rsCommG_numRows = 0; %> <% var rsCommH = Server.CreateObject("ADODB.Recordset"); rsCommH.ActiveConnection = MM_strDSN_STRING; rsCommH.Source = "SELECT * FROM comments WHERE TYPE = 'H'"; rsCommH.CursorType = 0; rsCommH.CursorLocation = 2; rsCommH.LockType = 3; rsCommH.Open(); var rsCommH_numRows = 0; %> <% var Repeat1__numRows = 1; var Repeat1__index = 0; rsF_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = 1; var Repeat1__index = 0; rsG_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = 1; var Repeat1__index = 0; rsH_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = 1; var Repeat1__index = 0; rsE_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = 1; var Repeat1__index = 0; rsD_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = 1; var Repeat1__index = 0; rsC_numRows += Repeat1__numRows; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; rsA_numRows += Repeat1__numRows; %> <% %> Rates

<%rsB.MoveNext();%><% while (!rsB.EOF) { %> <%rsB.MoveNext();%><% if (!rsB.EOF) %><%{%> <%rsB.MoveNext();%><%}%><%}%>
<%=(rsCommB.Fields.Item("header").Value)%>
<%=(rsB.Fields.Item("tyer").Value)%>
<%=(rsB.Fields.Item("rate").Value)%>
<%=(rsB.Fields.Item("apy").Value)%>
<%=(rsB.Fields.Item("term").Value)%>
<%=(rsB.Fields.Item("tyer").Value)%>
<%=(rsB.Fields.Item("rate").Value)%>
<%=(rsB.Fields.Item("apy").Value)%>
<%=(rsB.Fields.Item("term").Value)%>
<%=(rsB.Fields.Item("tyer").Value)%>
<%=(rsB.Fields.Item("rate").Value)%>
<%=(rsB.Fields.Item("apy").Value)%>
<%=(rsB.Fields.Item("term").Value)%>
<%=(rsCommB.Fields.Item("footer").Value)%>
<%rsA.MoveNext();%><% while (!rsA.EOF) { %> <%rsA.MoveNext();%><% if (!rsA.EOF) %><%{%> <%rsA.MoveNext();%><%}%><%}%>
<%=(rsCommA.Fields.Item("header").Value)%>
<%=(rsA.Fields.Item("tyer").Value)%>
<%=(rsA.Fields.Item("rate").Value)%>
<%=(rsA.Fields.Item("apy").Value)%>
<%=(rsA.Fields.Item("term").Value)%>
<%=(rsA.Fields.Item("tyer").Value)%>
<%=(rsA.Fields.Item("rate").Value)%>
<%=(rsA.Fields.Item("apy").Value)%>
<%=(rsA.Fields.Item("term").Value)%>
<%=(rsA.Fields.Item("tyer").Value)%>
<%=(rsA.Fields.Item("rate").Value)%>
<%=(rsA.Fields.Item("apy").Value)%>
<%=(rsA.Fields.Item("term").Value)%>
<%=(rsCommA.Fields.Item("footer").Value)%>
Back to Top




Equal Housing Lender
Member

Back to Top
<% rsA.Close(); %> <% rsB.Close(); %> <% rsC.Close(); %> <% rsD.Close(); %> <% rsE.Close(); %> <% rsF.Close(); %> <% rsG.Close(); %> <% rsH.Close(); %> <% rsCommA.Close(); %> <% rsCommB.Close(); %> <% rsCommC.Close(); %> <% rsCommD.Close(); %> <% rsCommE.Close(); %> <% rsCommF.Close(); %> <% rsCommG.Close(); %> <% rsCommH.Close(); %>