www.webdeveloper.com
Results 1 to 4 of 4

Thread: Display tables using ASP

  1. #1
    Join Date
    Mar 2006
    Posts
    4

    Display tables using ASP

    I an trying to create a web based database using ASP and Microsoft Access. I can retrieve data form the tables within Access. However, I use the html select tag and it puts the data into a drop down list. I would like to be able to display the data in a table in my browser. I tried using the table html tag, but that just displayed the data by itself. I very well could have forgotten something simple. Hopefully not. Any help would be appreciated. I can other info if needed. Thank you.

  2. #2
    Join Date
    Nov 2003
    Location
    Worthington, OH, USA
    Posts
    3,634
    Was going to write this up but remembered an example from W3Schools:
    <html>
    <body>

    <%
    set conn=Server.CreateObject("ADODB.Connection")
    conn.Provider="Microsoft.Jet.OLEDB.4.0"
    conn.Open(Server.Mappath("/db/northwind.mdb"))

    set rs = Server.CreateObject("ADODB.recordset")
    rs.Open "SELECT Companyname, Contactname FROM Customers", conn
    %>

    <table border="1" width="100%">
    <%do until rs.EOF%>
    <tr>
    <%for each x in rs.Fields%>
    <td><%Response.Write(x.value)%></td>
    <%next
    rs.MoveNext%>
    </tr>
    <%loop
    rs.close
    conn.close
    %>
    </table>

    </body>
    </html>
    54 68 65 42 65 61 72 4D 61 79

  3. #3
    Join Date
    Mar 2006
    Posts
    4
    Thank you, I will try this is out.

  4. #4
    Join Date
    Mar 2006
    Posts
    4
    I was to get that to work. I appreciate your help. Now I need to figure how to make the table variable. I was able to pull particular data using WHERE. However, that is hard coded. I would like that to be variable from whatever is selected on the previous page. I checked out W3 schools, but all they show me is a simple HTML donald duck example.

    Also, is Java the only way I can having "floating forms"? I would like to have two drop down menus and the data in the second one is dependent upon what is selected in the first. Hopefully ASP can do that. This should hopefully be all the help I ask for.

    Thank you,

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles