<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> <% var Recordset1__MMColParam = "1"; if (String(Request.QueryString("ID")) != "undefined" && String(Request.QueryString("ID")) != "") { Recordset1__MMColParam = String(Request.QueryString("ID")); } %> <% var Recordset1 = Server.CreateObject("ADODB.Recordset"); Recordset1.ActiveConnection = MM_realtors1_STRING; Recordset1.Source = "SELECT * FROM tbl_Agents WHERE ID = '"+ Recordset1__MMColParam.replace(/'/g, "''") + "'"; Recordset1.CursorType = 0; Recordset1.CursorLocation = 2; Recordset1.LockType = 3; Recordset1.Open(); var Recordset1_numRows = 0; %>

ID	<%=(Recordset1.Fields.Item("ID").Value)%>
RealtorName	<%=(Recordset1.Fields.Item("RealtorName").Value)%>
Agency	<%=(Recordset1.Fields.Item("Agency").Value)%>
OfficeAddress	<%=(Recordset1.Fields.Item("OfficeAddress").Value)%>
OfficeCity	<%=(Recordset1.Fields.Item("OfficeCity").Value)%>
OfficeState	<%=(Recordset1.Fields.Item("OfficeState").Value)%>
OfficeZip	<%=(Recordset1.Fields.Item("OfficeZip").Value)%>

<% Recordset1.Close(); %>