Create an HTML table from ADO Recordset (requires 1.4 SR-1)

Create an HTML table from ADO Recordset (requires 1.4 SR-1)



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
#macro( main $rs )
<table>
<tbody>
    <tr>
#foreach($field in $rs.Fields)
        <th>$field.Name</th>
#end
    </tr>
#foreach($record in $rs)
    <tr>
#foreach($field in $record)
        <td>$field.Value</td>
#end
    </tr>
#end
</tbody>
</table>
#end
#main( $rs )