get recordset value outside the table

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Hamster

    get recordset value outside the table

    I need to display data like this:

    CompanyName1

    Company | Date| Transactions Count -- headers
    CompanyName1 | Date| 1 -- data
    CompanyName2 | Date| 5 -- data
    CompanyName3 | Date| 2 -- data
    CompanyName4 | Date| 7 -- data



    COMPANYNAME1 should be outside the table
    <table>
    <tr>
    <%
    For each fld in objRS.Fields
    Response.Write( "<td>" & fld.Name & "</td>")
    Next
    objRS.MoveFirst
    %>
    </tr>
    <%
    Do until objRS.EOF
    %>
    <tr>
    <%
    For each fld in objRS.Fields
    Response.Write( "<td>" & fld & "</td>")
    Next
    objRS.MoveNext
    %>
    </tr>
    </table>

    Help please!
Working...