Home > ASP Development > Weekly Schedule

Weekly Schedule

I've been searching everywhere and I can't find a way to display my data like I want.

I need to display a weekly schedule in terms of:

time/day - Mo - Tu - We - Th - Fr - Sa - Su

7-8 x

8-9 x x

9-10 x x x x x

.....

I have my data in 3 tables: days (dayid,daytitle), times (timeid,timetitle), events (eventid,dayid,timeid,eventtitle)

I can display either the daytitle as column headers or timetitle as row headers by themselves, but not together, and definitely without the data.

Any help is appreciated (tutorials, code, references)

Thanks,

Jose

Guest

Sounds like you'll have to use some SQL INNER JOIN stuff.

Was this answer helpful ? Yes No

Guest

Quote:

Originally Posted by baseballdude_

Sounds like you'll have to use some SQL INNER JOIN stuff.

If I go to Access and do a crosstab query:

Code:

TRANSFORM First([dayslot Query].eventtitle) AS FirstOfeventtitle

SELECT [dayslot Query].myTime

FROM [dayslot Query]

GROUP BY [dayslot Query].myTime

PIVOT [dayslot Query].dayslot;

I can get "kind of" the results I want (it sorts my days by their name ie.. Monday, Sunday, Wednesday). I need to be able to pass this type of query into ASP and create the "spreadsheet" type data.

Was this answer helpful ? Yes No

Guest

Answer it

Ask Question About ASP Development

Weekly Schedule

Programming

Related Pages