[thelist] creating two-dimensional timetable in ASP/SQLServer
Elfur Logadottir
elfur at elfur.is
Sun Oct 13 13:41:01 CDT 2002
Hi,
i'm struggling with creating a two dimensional timetable in ASP.
i have a table with the following columns
id, title, day, timefrom, timeto
and in it there is an unknown amount of records, each storing information
about a class
for example these records:
32; bleh; 2; 17:30; 18:30
45; bleh; 4; 17:00; 18:00
what i need to do is display the records in a table with fixed axes. where
the vertical axis (Y) is time and horizontal axis (X) is day.
this wouldn't be a problem if i didn't have to display the length of the
class as well.
using the example rows above, i need to mark the Y-axis from 17:30 through
18:30 on monday (X-axis) and from 17:00 through 18:00 on wednesday.
so there, any suggestions?
thanks
elfur
*the puzzled one*
More information about the thelist
mailing list