Source code for stream_obs_report_form.cfm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML
4.01 Transitional//EN">
<CFQUERY name="SFUQuery" datasource="SFU">
SELECT * FROM SHIM WHERE SHIMID = '#OBJ_KEYS#'
ORDER BY DateSurveyed
</CFQUERY>
<html>
<head>
<title>Stream Observation Report Form</title>
</head>
<body>
<body bgcolor="#D7EBFF"></body>
<font face="Bookman Old Style" size="5" color="#0000FF"><em>Stream Observation
Point Data</em></font>
<br><font size="3">The following data has been entered for this point:</font>
<hr>
<CFTABLE
query="SFUQuery"
htmltable="Yes"
border
colheaders>
<CFCOL
text="#DateSurveyed#"
header="Survey Date"
>
<CFCOL
text="#FirstName# #Left(LastName, 1)#" <!---Shows first name and last
initial--->
header="Name"
>
<CFCOL
text="#StreamNameNearestTown#"
header="Stream Name or Nearest Town"
>
<CFCOL
text="#Weather#"
header="Weather"
>
<CFCOL
text="#Turbidity#"
header="Turbidity"
>
<CFCOL
text="#AirTemp"
header="Air Temperature (ºC)"
>
<CFCOL
text="#WaterTemp"
header="Water Temperature (ºC)"
>
</CFTABLE>
</body>
</html>