<% 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 Award!    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 Award FROM asla" set rstemp1=conntemp.execute(mySQL1) do until rstemp1.eof%>
<%=rstemp1("Award")%> <% newyear=rstemp1("Award") mySQL2="SELECT * FROM asla WHERE Award='" & newyear & "' ORDER BY AwardYear Desc" 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: Award Year:

View

View

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

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

Texas Chapter ASLA Copyright © 1999. All rights reserved. 

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