|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Populate Cells of A HTML Table Based on Strict Criterea |
|
From: |
neil frost |
|
Date: |
1/24/2001 4:56:58 AM |
|
IP: |
194.176.223.193 |
|
I''m creating a room booking system. I have a calendar which passes the selected date into the sql statement ie MYSQL = "SELECT * FROM mrbs WHERE BDate = #" & dtdate & "#" I can view the details for a specific date. What I am trying to do is have a static table with seven headings, Time, Meeting Room 1, Meeting Room 2.etc......Time. With 08:00 - 19:00 down the sides in rows. I want to be able to populate the table with the correct time based data from the database and leave fields blank that do not have any data associated. I have tried long winded IF statements, stored procedures etc but the same thing happens. I set the <%While not RS.EOF%> and at the bottom of the table <%RS.MoveNext Wend %> but this just repeats the table again or not at all. HOW CAN I HAVE A TABLE AND THE CELLS (BASED ON THE DATE AND TIME CRITERIA) FILLED FROM THE DATABASE WITHOUT THE TABLE REPEATING ITSELF?? PLEASE HELP |
Follow Up - Re: Populate Cells of A HTML Table Based on Strict Criterea - Aaron Butler 1/29/2001 4:56:00 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
