%@LANGUAGE="JAVASCRIPT"%> <% var Providers_list__MMColParam = "40"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { Providers_list__MMColParam = String(Request("MM_EmptyValue")); } %> <% var Providers_list = Server.CreateObject("ADODB.Recordset"); Providers_list.ActiveConnection = MM_CCommunity_DB_STRING; Providers_list.Source = "SELECT * FROM Providers WHERE Provider_number = "+ Providers_list__MMColParam.replace(/'/g, "''") + ""; Providers_list.CursorType = 0; Providers_list.CursorLocation = 2; Providers_list.LockType = 1; Providers_list.Open(); var Providers_list_numRows = 0; %> <% var Provider_legal__MMColParam = "40"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { Provider_legal__MMColParam = String(Request("MM_EmptyValue")); } %> <% var Provider_legal = Server.CreateObject("ADODB.Recordset"); Provider_legal.ActiveConnection = MM_CCommunity_DB_STRING; Provider_legal.Source = "SELECT * FROM Provider_legal_items WHERE Provider_number = "+ Provider_legal__MMColParam.replace(/'/g, "''") + ""; Provider_legal.CursorType = 0; Provider_legal.CursorLocation = 2; Provider_legal.LockType = 1; Provider_legal.Open(); var Provider_legal_numRows = 0; %> <% var Provider_desc__MMColParam = "40"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { Provider_desc__MMColParam = String(Request("MM_EmptyValue")); } %> <% var Provider_desc = Server.CreateObject("ADODB.Recordset"); Provider_desc.ActiveConnection = MM_CCommunity_DB_STRING; Provider_desc.Source = "SELECT * FROM Service_desc WHERE Provider_number = "+ Provider_desc__MMColParam.replace(/'/g, "''") + ""; Provider_desc.CursorType = 0; Provider_desc.CursorLocation = 2; Provider_desc.LockType = 1; Provider_desc.Open(); var Provider_desc_numRows = 0; %> <% var Provider_list__MMColParam = "40"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { Provider_list__MMColParam = String(Request("MM_EmptyValue")); } %> <% var Provider_list = Server.CreateObject("ADODB.Recordset"); Provider_list.ActiveConnection = MM_CCommunity_DB_STRING; Provider_list.Source = "SELECT * FROM Providers WHERE Provider_number = "+ Provider_list__MMColParam.replace(/'/g, "''") + ""; Provider_list.CursorType = 0; Provider_list.CursorLocation = 2; Provider_list.LockType = 1; Provider_list.Open(); var Provider_list_numRows = 0; %> <% var Provider_contact__MMColParam = "40"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { Provider_contact__MMColParam = String(Request("MM_EmptyValue")); } %> <% var Provider_contact = Server.CreateObject("ADODB.Recordset"); Provider_contact.ActiveConnection = MM_CCommunity_DB_STRING; Provider_contact.Source = "SELECT * FROM Provider_contacts WHERE Provider_number = "+ Provider_contact__MMColParam.replace(/'/g, "''") + " ORDER BY Sort_field ASC"; Provider_contact.CursorType = 0; Provider_contact.CursorLocation = 2; Provider_contact.LockType = 1; Provider_contact.Open(); var Provider_contact_numRows = 0; %> <% var Provider_internet__MMColParam = "40"; if (String(Request("MM_EmptyValue")) != "undefined" && String(Request("MM_EmptyValue")) != "") { Provider_internet__MMColParam = String(Request("MM_EmptyValue")); } %> <% var Provider_internet = Server.CreateObject("ADODB.Recordset"); Provider_internet.ActiveConnection = MM_CCommunity_DB_STRING; Provider_internet.Source = "SELECT Contact_label, Hyperlink_name, Link FROM Provider_internet WHERE Provider_number = "+ Provider_internet__MMColParam.replace(/'/g, "''") + " ORDER BY Sort_field ASC"; Provider_internet.CursorType = 0; Provider_internet.CursorLocation = 2; Provider_internet.LockType = 1; Provider_internet.Open(); var Provider_internet_numRows = 0; %> <% var Repeat1__numRows = -1; var Repeat1__index = 0; Provider_legal_numRows += Repeat1__numRows; %> <% var Repeat3__numRows = -1; var Repeat3__index = 0; Provider_internet_numRows += Repeat3__numRows; %> <% var Repeat2__numRows = -1; var Repeat2__index = 0; Provider_contact_numRows += Repeat2__numRows; %>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||