<% Set rsBD = GetRecordset("SELECT * FROM tbl_Anniv Where str_anniv_BornMonth = '" & ThisMonth & "' AND str_anniv_Died = 'N/A' ORDER BY str_anniv_BornDay;", True)
'Make sure there are results
If rsBD.State =0 Or rsBD.EOF And rsBD.BOF Then %>
| Happy Birthday List |
| (No Birthdays in this Month) |
<% Else %>
| Happy Birthday List |
<% rsBD.MoveFirst
While Not rsBD.EOF %>
| <%=rsBD("str_anniv_FirstName")%> <%=rsBD("str_anniv_MiddleName")%> On - <%=rsBD("str_anniv_BornMonth")%>/<%=rsBD("str_anniv_BornDay")%> |
<% rsBD.MoveNext
Wend %>
<% End If %>
|
<% Set rsAnn = GetRecordset("SELECT * FROM tbl_Anniv Where str_anniv_MarriedMonth = '" & ThisMonth & "' AND str_anniv_Died = 'N/A' AND str_anniv_Couple<>'' ORDER BY str_anniv_MarriedDay;", True)
'Make sure there are results
If rsAnn.State =0 Or rsAnn.EOF And rsAnn.BOF Then %>
| Happy Anniversary List |
| (No Anniversary's in this Month) |
<% Else %>
| Happy Anniversary List |
<% rsAnn.MoveFirst
While Not rsAnn.EOF %>
| <%=rsAnn("str_anniv_Couple")%> On - <%=rsAnn("str_anniv_MarriedMonth")%>/<%=rsAnn("str_anniv_MarriedDay")%>/<%=rsAnn("str_anniv_MarriedYear")%> |
<% rsAnn.MoveNext
Wend %>
<% End If %>
|
<% Set rsBD = GetRecordset("SELECT * FROM tbl_Anniv Where str_anniv_DiedMonth = '" & ThisMonth & "' AND str_anniv_Died <> 'N/A' ORDER BY str_anniv_DiedDay;", True)
'Make sure there are results
If rsBD.State =0 Or rsBD.EOF And rsBD.BOF Then %>
<% Else %>
| Memory Box |
<% rsBD.MoveFirst
While Not rsBD.EOF %>
| <%=rsBD("str_anniv_FirstName")%> <%=rsBD("str_anniv_MiddleName")%> From - <%=rsBD("str_anniv_BornMonth")%>/<%=rsBD("str_anniv_BornDay")%>/<%=rsBD("str_anniv_BornYear")%> To - <%=rsBD("str_anniv_DiedMonth")%>/<%=rsBD("str_anniv_DiedDay")%>/<%=rsBD("str_anniv_DiedYear")%> |
<% rsBD.MoveNext
Wend %>
<% End If %>
|