I’m fairly new to web development and I’m trying to figure out something that should be fairly straight forware:
I have a page and the user enters a beginning date and an ending date. I want to use ASP/VBScript to run a SQL query and get back a recordset from MSAccess. Then loop through the recordset displaying the results in a table on the page. I’ve figured out how to connect to the database and get back the resultset, but how do I loop through the recordset and build the table to display the query results on the page. The table will need to have 6 columns, and I obviously don’t know how many rows, it will depend on the date range.
Thanks,
Mike T.