<% function showSchedule(theMonth,theYear) turnOffDate = dateadd("d",-6,now) 'cQ = "select scheduleID,thedate,enddate,eventname,description from SCHEDULE where active=1 and " &_ ' "Month(thedate) = " & theMonth & " AND Year(thedate) = " & theYear & " order by thedate" cQ = "select scheduleID,thedate,enddate,eventname,datediff(d,thedate,enddate) as dadate, description from SCHEDULE where active=1 and " cQ = cQ & "Month(thedate) = " & theMonth & " AND Year(thedate) = " & theYear & " " if dadate >= 1 then cQ = cQ & " and thedate > '" & turnOffDate & "' " else cQ = cQ & " and enddate > '" & turnOffDate & "' " end if cQ = cQ & "order by thedate" if request.querystring("showQ") = "yes" then response.write cQ set cRS = connect.execute(cQ) if not cRS.eof then showSchedule = showSchedule & "" showSchedule = showSchedule & "" & ucase(MonthName(theMonth)) & "" showSchedule = showSchedule & "" do until cRS.eof thedate = cRS("thedate") theday = DatePart("w", thedate) theEndDate = cRS("enddate") theEndDay = DatePart("w", theEndDate) if theEndDate > thedate then showdate = WeekdayName(theday,true) & "., " & MonthName(Month(thedate)) & " " & DatePart("d", thedate) showdate = showdate & " - " & WeekdayName(theEndDay,true) & "., " & MonthName(Month(theEndDate)) & " " & DatePart("d", theEndDate) else showdate = WeekdayName(theday,true) & "., " & MonthName(Month(thedate)) & " " & DatePart("d", thedate) end if showSchedule = showSchedule & "" showSchedule = showSchedule & "" showSchedule = showSchedule & "" showSchedule = showSchedule & "" & cRS("eventname") & "
" 'showSchedule = showSchedule & WeekdayName(theday,true) & "., " & MonthName(Month(thedate)) & " " & DatePart("d", thedate) showSchedule = showSchedule & showdate thedesc = trim(cRS("description")) if thedesc <> "" then showSchedule = showSchedule & "
" & thedesc showSchedule = showSchedule & "" showSchedule = showSchedule & "" cRS.movenext loop end if cRS.close set cRS = nothing end function %> Chinese American International School: Leading the Way in Teaching Chinese Language and Culture
 





Chinese American
International School


CAIS is the nation's pre-eminent and oldest school offering Chinese-English immersion education.

Founded in 1981, CAIS is a preK-8th grade independent school in San Francisco, California that provides a bilingual and multicultural learning experience for students of all backgrounds.


2008 Summer Program Brochure Now Available!
Download the PDF





<% nQ = "select newsID,title from news where active=1 and spotlight=1 order by sortorder, title" set nRS = connect.execute(nQ) if not nRS.eof then do until nRS.eof %> <% nRS.movenext loop end if nRS.close set nRS = nothing %>
CAIS News
">
<%= nRS("title") %>
<% interval = 2 si = 0 '-1 do while si <= (interval - 1) newdate = DateAdd("m",si,Now) response.write showSchedule(DatePart("m", newdate),DatePart("yyyy", newdate)) si = si + 1 loop %>
Calendar
2007-2008