<%@LANGUAGE="VBSCRIPT"%> <% Dim rsContent__MMColParam rsContent__MMColParam = "1" if (Request.QueryString("category_ID") <> "") then rsContent__MMColParam = Request.QueryString("category_ID") %> <% set rsContent = Server.CreateObject("ADODB.Recordset") rsContent.ActiveConnection = MM_connCategories_STRING rsContent.Source = "SELECT * FROM content WHERE category_ID = '" + Replace(rsContent__MMColParam, "'", "''") + "'" rsContent.CursorType = 0 rsContent.CursorLocation = 2 rsContent.LockType = 3 rsContent.Open() rsContent_numRows = 0 %> <% set rsNavigation = Server.CreateObject("ADODB.Recordset") rsNavigation.ActiveConnection = MM_connCategories_STRING rsNavigation.Source = "SELECT category_ID, category_name FROM categories ORDER BY order_by ASC" rsNavigation.CursorType = 0 rsNavigation.CursorLocation = 2 rsNavigation.LockType = 3 rsNavigation.Open() rsNavigation_numRows = 0 %> <% Dim rsBody__MMColParam rsBody__MMColParam = "1" if (Request.QueryString("category_ID") <> "") then rsBody__MMColParam = Request.QueryString("category_ID") %> <% set rsBody = Server.CreateObject("ADODB.Recordset") rsBody.ActiveConnection = MM_connCategories_STRING rsBody.Source = "SELECT * FROM categories WHERE category_ID = '" + Replace(rsBody__MMColParam, "'", "''") + "'" rsBody.CursorType = 0 rsBody.CursorLocation = 2 rsBody.LockType = 3 rsBody.Open() rsBody_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 rsNavigation_numRows = rsNavigation_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Repeat2__numRows = -1 Dim Repeat2__index Repeat2__index = 0 rsContent_numRows = rsContent_numRows + Repeat2__numRows %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each Item In Request.QueryString NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item)) End If Next ' add the Form variables to the MM_keepForm string For Each Item In Request.Form NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> City Creek Mortgage
'

<% While ((Repeat1__numRows <> 0) AND (NOT rsNavigation.EOF)) %>
" class="lnk"><%=(rsNavigation.Fields.Item("category_name").Value)%>
<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rsNavigation.MoveNext() Wend %>

"The Highest Compliment I can ever receive is a personal referral
from you."

<% If Not rsContent.EOF Or Not rsContent.BOF Then %> <% While ((Repeat2__numRows <> 0) AND (NOT rsContent.EOF)) %> " class="lnkC"><%=(rsContent.Fields.Item("link_name").Value)%> | <% Repeat2__index=Repeat2__index+1 Repeat2__numRows=Repeat2__numRows-1 rsContent.MoveNext() Wend %> <% End If ' end Not rsContent.EOF Or NOT rsContent.BOF %>

<%=(rsBody.Fields.Item("headline").Value)%>

<%=(rsBody.Fields.Item("body_text").Value)%>

<%=(rsBody.Fields.Item("right_headline").Value)%>
<%=(rsBody.Fields.Item("right_text").Value)%>

">
<%=(rsBody.Fields.Item("quote").Value)%>
<% rsContent.Close() %> <% rsNavigation.Close() %> <% rsBody.Close() %>