|
<%=sGenus%> <%=sSpeciesVariety%> |
<%
'Get photos, if any
sSQL = "SELECT * FROM PicturesForPalm WHERE PalmID = " & sPalmID
Set rs2 = oConn.Execute(sSQL)
If Not rs2.EOF Then%>
|
|
<%
rs2.Close
Else%>
We need a photo!
|
<%End If%>
 Upload
a picture of a palm to our site!
If you have a photo of this palm, please
upload the file to
our website. All we ask for is your name, the species and any description you would like displayed
with the picture.
If you don't have an electronic copy, you can mail it to the
Webmaster. Send an email and we'll get back to you with our mailing address.
|
| Common names: |
<%=GetCommonNames(sPalmID) & rs("CommonName")%> |
Add a common name |
<% If sPlantType = 1 Then %>
| Leaf Type: |
<%=rs("LeafTypeMajor")%> |
Growth Habit: |
<%=rs("GrowthHabit")%> |
<% End If
sIntro = ""
If sIntro <> "" Then%>
|
|
<%
End If
If Not rs.EOF Then %>
Observations
|
|
|
<%
Dim sEmail, sName, sMap, sURL
i = 1
If rs("ObservationDate") <> "" Then
Do While Not rs.EOF %>
| Observer: |
<%sEmail = rs("Email")
sName = rs("Name")
If sEmail <> "" Then
If sName <> "" Then
sEmail = "" & sName & ""
Else
sEmail = "" & sName & ""
End If
End If%>
<%=sEmail%> |
Observation Date: |
<%=rs("ObservationDate")%> |
<%If sName <> "" Then %>
|
View all observations from <%=sName%> |
<% End If
sURL = Trim(rs("URL"))
If sURL <> "" Then%>
| Observer's Website: |
<%
If Left(sURL,7) <> "http://" Then
sURL = "http://" & sURL
End If
sURL = ""
If Trim(rs("URLText")) <> "" Then
sURL = sURL & rs("URLText")
Else
sURL = sURL & rs("URL")
End If
sURL = sURL & ""
%>
<%=sURL%> |
<%End If%>
| City: |
<%=rs("City")%> |
State: |
<%=rs("State")%> |
| Country: |
<%=rs("Country")%> |
Postal Code: |
| USDA Zone: |
<%=rs("USDAZone")%> |
|
|
| Soil Description: |
<%=rs("SoilDescription")%> |
| Age of Plant (years): |
<%=rs("Age")%> |
Height of Plant (feet): |
<%=rs("Height")%> |
| Growth Rate: |
<%=rs("GrowthRate")%> |
Suitability for your area: |
<%=rs("Suitability")%> |
| Heat Tolerance (F): |
<%=rs("HeatTolerance")%> |
Humidity Tolerance: |
<%=rs("HumidityTolerance")%> |
| Frost Tolerance: |
<%=rs("FrostTolerance")%> |
Cold Tolerance (F): |
<%
sCold = ""
If Trim(rs("ColdTolerance")) = 9 Then
sCold = rs("ColdTolerance") & "° or lower"
Else
If Trim(rs("ColdTolerance")) <> "" Then
sCold = ">=" & rs("ColdTolerance") & "°"
End If
End If%>
<%=sCold%> |
| Light Requirements: |
<%=rs("LightRequirement")%> |
Tolerance of Indoor Conditions: |
<%=rs("IndoorTolerance")%> |
| Observations & Comments: |
| <%=rs("Observation")%> |
|
<%
rs.MoveNext
Loop
Else%>
Currently there are no observations for this species.
Be a sport and
add the first one.
|
<%
End If
rs.Close
End If%>
|
|
|
Find Information About <%=sFullName%> on These Other Sites
|
|
<%
End If%><%Footer%>
|