<% myDSN="DSN=aslatx" set conntemp=server.createobject("adodb.connection") conntemp.open myDSN %>
LANDSCAPE ARCHITECTURE AWARD WINNERS ARCHIVE
TEXAS CHAPTER AMERICAN SOCIETY OF LANDSCAPE ARCHITECTS

                            

                           Listed by the Year Awarded!       Archive Home

The following records matched your query.  Select an action for the record you wish to VIEW the Project Description and Illustrations . Select BIO if you wish to view Project Abstract.

<% myDSN="DSN=aslatx" set conntemp=server.createobject("adodb.connection") conntemp.open myDSN %>
<%mySQL1="SELECT DISTINCT AwardYear FROM asla ORDER BY AwardYear Desc" set rstemp1=conntemp.execute(mySQL1) do until rstemp1.eof%>
<%=rstemp1("AwardYear")%> <% newyear=rstemp1("AwardYear") mySQL2="SELECT * FROM asla WHERE AwardYear='" & newyear & "' ORDER BY ProjectName" set rstemp2=conntemp.execute(mySQL2) do until rstemp2.eof %> <%my_link1=rstemp2("Hyperlink") & "?which=" & rstemp2("Abbraviations")%> <%if ISNULL (rstemp2("Hyperlink")) then%> <%else%> <%end if%> <% rstemp2.movenext loop %> <% rstemp1.movenext loop %>
Action: Project Name: Project Award:

View

View

<%=rstemp2("ProjectName")%> ">Bio <%=rstemp2("Award")%>

                                          Archive Home  ::   Archive History   ::   Research   ::  About the Website

Texas Chapter ASLA Copyright 1999. All rights reserved. 

<% conntemp.close set conntemp=nothing response.end %>