<% //CheckSession() set con=Server.CreateObject("ADODB.Connection") con.Open DB_CON set rsVillage=Server.CreateObject("ADODB.RecordSet") rsVillage.Open "SELECT * FROM tbVillage ORDER BY txtVillageName",con set rsAttention=Server.CreateObject("ADODB.RecordSet") rsAttention.Open "SELECT * FROM tbAttentionLevel ORDER BY txtattnLevel",con set rsStatus=Server.CreateObject("ADODB.RecordSet") rsStatus.Open "SELECT * FROM tbMemberStatus",con set rsResp=Server.CreateObject("ADODB.RecordSet") rsResp.Open "SELECT * FROM tbResponsible ORDER BY txtResponsible",con set rsToilet=Server.CreateObject("ADODB.RecordSet") rsToilet.Open "SELECT * FROM tbToilet ORDER BY intTStatusID",con set rsFamStatus=Server.CreateObject("ADODB.RecordSet") rsFamStatus.Open "SELECT * FROM tbFamilyStatus ORDER BY txtFamilyStatus",con set rsEduc=Server.CreateObject("ADODB.RecordSet") rsEduc.Open "SELECT * FROM tbEducation",con rowcolor1="#D9E8E8" rowcolor2="#EFEFEF" if session("useremail")<>"" then Response.Write(Navigation("viewentry")) else fonts="" fonte="" Response.Write(""+fonts+"Login"+fonte+"    ") Response.Write(""+fonts+"Reports"+fonte+"") end if %> Search Census Entries
> > > > > > > > > > > > > > > > > > > > > > > > > > >
House No contains
House Address contains
Phone no contains
Comments contains
Date Of Census From Click to select a date! To Click to select a date! OR    On Click to select a date!
Has Toilet? <% while not rsToilet.EOF %> "> <%=rsToilet("txtToiletStatus")%> <% rsToilet.MoveNext wend %>
Family Problem contains
Family Problem Solvable By <%rsResp.MoveFirst%> <%=selectbox("intResponPersonIDFP",rsResp,"intResponsiblePersonID","txtResponsible","1","1","0")%>
Family Problem Attention Level <%rsAttention.MoveFirst%> <%=selectbox("intAttnLevelIDFP",rsAttention,"intAttnLevelID","txtattnLevel","1","1","0")%>
Family Status <%=selectbox("intFamStatusID",rsFamStatus,"intFamStatusID","txtFamilyStatus","1","1","0")%>
Village Problem contains
Village Problem Solvable By <%rsResp.MoveFirst%> <%=selectbox("intResponPersonIDVP",rsResp,"intResponsiblePersonID","txtResponsible","1","1","0")%>
Village Problem Attention Level <%rsAttention.MoveFirst%> <%=selectbox("intAttnLevelIDVP",rsAttention,"intAttnLevelID","txtattnLevel","1","1","0")%>
Village Name <%=selectbox("intVillageID",rsVillage,"intVillageID","txtVillageName","1","1","0")%>
Member Name contains
Member Age between and OR equals
Member Sex MF
Member Status <%=selectbox("intMemberStatusID",rsStatus,"intMemberStatusID","txtMemberStatus","1","1","0")%>
Member Education <%=selectbox("intEducationID",rsEduc,"intEducationID","txtEducation","1","1","0")%>
Member Specific Degree contains
Member Relationship contains
About the member contains
Interested in SSL? YesNo
Member Problem contains
Member Problem Solvable By <%rsResp.MoveFirst%> <%=selectbox("intResponPersonIDMP",rsResp,"intResponsiblePersonID","txtResponsible","1","1","0")%>
Member Problem Attention Level <%rsAttention.MoveFirst%> <%=selectbox("intAttnLevelIDMP",rsAttention,"intAttnLevelID","txtattnLevel","1","1","0")%>
Member Suggestion contains
                                          Records per page