<% 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 Landscape Category!           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 Classification FROM asla" set rstemp1=conntemp.execute(mySQL1) do until rstemp1.eof%>
<%=rstemp1("Classification")%> <% newyear=rstemp1("Classification") mySQL2="SELECT * FROM asla WHERE Classification='" & 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 %>