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 (&ordm;C)"
>
<CFCOL
text="#WaterTemp"
header="Water Temperature (&ordm;C)"
>
</CFTABLE>

</body>
</html>

Back