[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