#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Posts
    58
    Rep Power
    11

    how to display records in vbscript in table


    hii theree

    I have a set of records in a table in acces. I want to display these records in a table format using vbscript/ADO connection. can anyone tell me how to do this for all the records since vbscript does not allow the table tag to work in its own tag...so plss tell me how to do this ...
    thanks

    ravi
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Melbourne, Australia
    Posts
    212
    Rep Power
    12
    You need to create the table outside of the vbscript. e.g.
    Code:
    <table>
       <tr>
          <!--- put your table headers in this row --->
        </tr>
    
       <% ' now go through your records and create a new row for each
         Do While NOT recordset.EOF %>
             <tr>
              <!--- put your record values in here as per headers --->
             </tr>
         <% ' get the next record
               recordset.MoveNext
         Loop %>
    </table>
    Hope this helps.
    How can I soar like an eagle when
    I'm flying with turkey's?

IMN logo majestic logo threadwatch logo seochat tools logo