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.
Was going to write this up but remembered an example from W3Schools:
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT Companyname, Contactname FROM Customers", conn
<table border="1" width="100%">
<%do until rs.EOF%>
<%for each x in rs.Fields%>
54 68 65 42 65 61 72 4D 61 79
Thank you, I will try this is out.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)