MCNAMARA KOENIG & MCCARTHY PC

<%@LANGUAGE="JAVASCRIPT"%> <% var rsCorporate__MMColParam = "corporate_main"; if(String(Request("MM_EmptyValue")) != "undefined") { rsCorporate__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsCorporate = Server.CreateObject("ADODB.Recordset"); rsCorporate.ActiveConnection = MM_connWhiteMcd_STRING; rsCorporate.Source = "SELECT title, description, body FROM content WHERE location = '"+ rsCorporate__MMColParam.replace(/'/g, "''") + "'"; rsCorporate.CursorType = 0; rsCorporate.CursorLocation = 2; rsCorporate.LockType = 3; rsCorporate.Open(); var rsCorporate_numRows = 0; %> <% var rsDeals__MMColParam = "live"; if(String(Request("MM_EmptyValue")) != "undefined") { rsDeals__MMColParam = String(Request("MM_EmptyValue")); } %> <% var rsDeals = Server.CreateObject("ADODB.Recordset"); rsDeals.ActiveConnection = MM_connWhiteMcd_STRING; rsDeals.Source = "SELECT * FROM deals WHERE status = '"+ rsDeals__MMColParam.replace(/'/g, "''") + "' ORDER BY sort_order ASC"; rsDeals.CursorType = 0; rsDeals.CursorLocation = 2; rsDeals.LockType = 3; rsDeals.Open(); var rsDeals_numRows = 0; %> <% var Repeat2__numRows = 10; var Repeat2__index = 0; rsCorporate_numRows += Repeat2__numRows; %> <% var MM_paramName = ""; %> <% // *** 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 var MM_removeList = "&index="; if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "="; var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone=""; // add the URL parameters to the MM_keepURL string for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) { var nextItem = "&" + items.item().toLowerCase() + "="; if (MM_removeList.indexOf(nextItem) == -1) { MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item())); } } // add the Form variables to the MM_keepForm string for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) { var nextItem = "&" + items.item().toLowerCase() + "="; if (MM_removeList.indexOf(nextItem) == -1) { MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item())); } } // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1); %> MCNAMARA KOENIG & MCCARTHY PC - Deals Page




		Back to Representative Transactions:

<% rsCorporate.Close(); %> <% rsDeals.Close(); %>