Quick Link   Residential Projects Commercial Projects Back to Projects <% set rsLocationMaster= server.CreateObject("ADODB.Recordset") strSql = "select * from Location_Master" rsLocationMaster.open strSql,myConn,1,3 %> <% set rsTypeMaster= server.CreateObject("ADODB.Recordset") strSql = "select * from Type_Master" rsTypeMaster.open strSql,myConn,1,3 %> <% set rsPossessionMaster= server.CreateObject("ADODB.Recordset") strSql = "select * from Possession_Master" rsPossessionMaster.open strSql,myConn,1,3 %> Location <%while not rsLocationMaster.EOF%> "><%=rsLocationMaster("Location_Name")%> <% rsLocationMaster.MoveNext wend 'myConn.close set rsLocationMaster = nothing %> Type <%while not rsTypeMaster.EOF%> "><%=rsTypeMaster("Type_Name")%> <% rsTypeMaster.MoveNext wend 'myConn.close set rsTypeMaster = nothing %>   Possession <%while not rsPossessionMaster.EOF%> "><%=rsPossessionMaster("Possession_Name")%> <% rsPossessionMaster.MoveNext wend set rsPossessionMaster = nothing %>       Future Projects