Creating HTML Table from Recordset (VBScript)
:
Return to List
' This code block builds an HTML table from a recordset -- NOTE how the code is laid out
<%
Do Until RSEquip.EOF
TempEquipmentDescription = RSEquip("EquipmentDescription")
TempLocation = RSEquip("EquipmentLocation")
TempName = RSEquip("EmpName")
TempEMail = RSEquip("EmailAddress")
TheStuff = TempEmail & """>" & TempName
%>
<TR>
<TD><P><A HREF="../html/information.asp?EquipmentID =
<% response.write RSEquip("EquipmentID") %> ">
<% response.write RSEquip("EquipmentName") &></A>
</TD>
<TD>
<P><% response.write TempEquipmentDescription %>
</TD>
<TD>
<P><% response.write TempLocation %>
</TD>
<TD>
<P><A HREF="mailto:<% response.write TheStuff %></A>
</TD>
</TR>
<%
RSEquip.MoveNext
Loop
%>
Note to Webmaster