|
|
|
nformation for new residents of Callaway County www.callaway.county.missouri.org
<%
rsCategories.Open "SELECT * FROM Categories ORDER BY cat_order", Database, 3, 3
rsLinks.Open "SELECT * FROM Links", Database, 3, 3
Do Until rsCategories.EOF
rsResidents.Open "SELECT * from Residents WHERE res_cat='" & rsCategories("cat_name") & "' ORDER BY res_order", Database, 3, 3
If NOT rsResidents.EOF Then
%>
<%=rsCategories("cat_name")%> |
<%
End If
Do Until rsResidents.EOF
If background = "dark" Then
Response.Write ""
background = "light"
Else
Response.Write " "
background = "dark"
End If
%>
<%
For Each Item in rsResidents.Fields
If Item.Name <> "res_ID" and Item.Name <> "res_cat" and Item.Name <> "res_order" and rsResidents(Item.Name) <> "" Then
If Item.Name = "res_email" Then
Response.Write "E-Mail Address" & " " & vbCrlF
ElseIf Item.Name = "res_web" Then
Response.Write "Web Address" & " " & vbCrlF
Else
Response.Write rsResidents(Item.Name) & " " & vbCrlF
End If
End If
Next
%>
|
<%
rsResidents.MoveNext
%>
<%
If rsResidents.EOF Then
Response.Write " " & vbCrlF
Else
For Each Item in rsResidents.Fields
If Item.Name <> "res_ID" and Item.Name <> "res_cat" and Item.Name <> "res_order" and rsResidents(Item.Name) <> "" Then
If Item.Name = "res_email" Then
Response.Write "E-Mail Address" & " " & vbCrlF
ElseIf Item.Name = "res_web" Then
Response.Write "Web Address" & " " & vbCrlF
Else
Response.Write rsResidents(Item.Name) & " " & vbCrlF
End If
End If
Next
End If
%>
|
<%
If Not rsResidents.EOF Then
rsResidents.MoveNext
End If
Loop
rsResidents.Close
rsCategories.MoveNext
Loop
If NOT rsLinks.EOF Then
%>
Links for More Information About Title Insurance: |
<%
End If
Do Until rsLinks.EOF
If background = "dark" Then
Response.Write ""
background = "light"
Else
Response.Write " "
background = "dark"
End If
%>
<%
Response.Write rsLinks("link_name") & " " & vbCrLf
Response.Write "" & rsLinks("link_address") & " " & vbCrLf
%>
|
<%
rsLinks.MoveNext
%>
<%
If rsLinks.EOF Then
Response.Write " " & vbCrlF
Else
Response.Write rsLinks("link_name") & " " & vbCrLf
Response.Write "" & rsLinks("link_address") & " " & vbCrLf
End If
%>
|
<%
If Not rsLinks.EOF Then
rsLinks.MoveNext
End If
Loop
%>
|
|