<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/Results.asp" -->
<%
Dim Recordset1__MMColParam1
Recordset1__MMColParam1 = "1"
If (Request.QueryString("ID Number") <> "") Then
Recordset1__MMColParam1 = Request.QueryString("ID Number")
End If
%>
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.QueryString("FirstName") <> "") Then
Recordset1__MMColParam = Request.QueryString("FirstName")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_Results_STRING
Recordset1.Source = "SELECT * FROM dbo.[Show All Info2] WHERE [ID Number] = '" + Replace(Recordset1__MMColParam1, "'", "''") + "' AND FirstName Like '" + Replace(Recordset1__MMColParam, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="250" border="1" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<p> </p>
<table width="250" border="1" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<p> </p>
<table align="center" border="1">
<tr>
<td align="default" width="50%">ID Number</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("ID Number").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Title</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("Title").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">FirstName</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("FirstName").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">MiddleName</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("MiddleName").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">LastName</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("LastName").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Suffix</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("Suffix").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Apt #</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Apt #]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">House #</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[House #]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">HouseNoSuffix</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("HouseNoSuffix").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Street Name</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Street Name]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">City</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("City").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">State</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("State").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Zip Code</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Zip Code]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">DateOfBirth</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("DateOfBirth").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Date Registered</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Date Registered]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Last Date Voted</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Last Date Voted]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Precinct Split ID</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Precinct Split ID]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">PrecinctCode</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("PrecinctCode").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Political Party</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Political Party]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Voter Status</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Voter Status]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Ward</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("Ward").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Sch Dist</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Sch Dist]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">SD Zone</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[SD Zone]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">JP Dist</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[JP Dist]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">JP_Name</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[JP_Name]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">St Rep</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[St Rep]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">State_Rep_Name</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("State_Rep_Name").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">St Sen</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[St Sen]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">State_Sen_Name</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("State_Sen_Name").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Congress</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("Congress").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Jud Dist</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Jud Dist]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">City Limit</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[City Limit]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">DC</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("DC").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Polling Place Description</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("[Polling Place Description]").Value)%></td>
</tr>
<tr>
<td align="default" width="50%">Location</td>
<td align="default" width="50%"><%=(Recordset1.Fields.Item("Location").Value)%></td>
</tr>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
And this, the last one is Details.asp