I am trying to put together a classic asp page that will show different values for different dates for 6 different locations, example:
[11/29/07] [Location 1] [200]
in my tables each location has its own code and the dates need to be dynamic, there may be some dates where there is no data in this case i want the web page to display "Open" I know if i open a record set with a query i can do a record count and if it is null then i can default the value to "open" on the page But i need to do this 90 times (90 days)* 6 locations and since each location sits next to each other on the page ex:
Date | Location 1 | Location 2 | and so on
i need to grab each value for each location 1 date at a time and i dont want to open and close the record set over and over to run a different query each time. But I don't know of any way to run a query directly against a DB from within ASP and i just can't think of another way to do it. So if anyone know a way to A. Directly query a table from ASP or has a better suggestion other then to open and close the recordset over and over again (this just dosen't seem like an efficient way to do it) please share :)

Thanks,
Jim

It shouldn't be any problem to loop through the locations calling your SQL queries from within the loop without opening and closing your connection or your recordset. You can set your recordset to nothing but I think you can also just refill it with data on every pass. And also write your html within the loop.