[/if]
~[tlist_sql;SELECT bs.id, bs.Name
FROM Calendar_Day cd
INNER JOIN Bell_Schedule bs ON cd.Bell_Schedule_ID = bs.ID
WHERE cd.date_value = trunc(sysdate)
AND cd.SchoolID =~(curschoolid);nonemessage=
~[tlist_sql;select Teachers.email_addr, Courses.Course_Name,
CC.Expression, Teachers.LastFirst,
Sections.Room, Sections.ID, Sections.TermID
from Sections, Teachers, Courses, Terms, CC
where ABS(CC.SectionID) = Sections.ID
and Sections.Teacher = Teachers.ID
and Courses.Course_Number = Sections.Course_Number
and Terms.ID = Sections.TermID
and Terms.SchoolID = Sections.SchoolID
;alternatecolor;currentschedule]