1
Download coen-2003-project-27.. - Computer Engineering
Transcript
<td><p align="left"><font color="#000000" face="Arial" size="3"><%=DB_Results("DailyRepeat")%>
</font></p></td>
<td><p align="left"><font color="#000000" face="Arial" size="3"><%=DB_Results("EndDate")%>
</font></p></td>
</tr>
<%
set getID = DB.Execute("SELECT * FROM event_sequence WHERE Name = " & "'" &pageName & "'")
'response.Write(getID("ID"))
tempString = "SELECT * FROM ES_effects_WU WHERE ESID ="& getID("ID") & " ORDER BY WUID"
'response.Write (tempString)
set temp_Results = DB.Execute(tempString)
%>
<tr></tr>
<tr></tr>
<tr>
<td></td>
<td bgcolor=LightBlue><p align="center"><font color="Blue" face="Arial" size="2"><b>Involved
Wall Units</b></font></p></td>
<td bgcolor=LightBlue><p align="center"><font color="Blue" face="Arial"
size="2"><b>ID</b></font></p></td>
<td bgcolor=LightBlue><p align="center"><font color="Blue" face="Arial"
size="2"><b>Name</b></font></p></td>
<td bgcolor=LightBlue><p align="center"><font color="Blue" face="Arial"
size="2"><b>Location</b></font></p></td>
<td bgcolor=LightBlue><p align="center"><font color="Blue" face="Arial"
size="2"><b>Operation</b></font></p></td>
</tr>
<%
while not temp_Results.eof
set tempWUID = temp_Results("WUID")
SearchString2 = "SELECT * FROM Wall_Unit WHERE ID =" & tempWUID
set DB_Results2 = DB.Execute(SearchString2)
