%Language=VBSCRIPT%>
<%Response.Buffer = True%>
<% If Cint(Request.QueryString("PageID"))= 0 then
PID = 49
end if
maintenance = ""
'maintenance = "irishfilm.ie is currently undergoing maintenance, some links may not function correctly, sorry for any inconvenience.
"
%>
<%
Session.LCID = 1033
dark = "003366"
middle = "669999"
light = "CCCCFF"
T_Films = "
| ::Job Opportunities:: | |
"
data_source = "ifi_cinemobile"
Set rsSQL = CreateObject("ADODB.Recordset")
Set MyConn = Server.CreateObject("ADODB.Connection")
TDate = Date()
Set rsSQLVenue = CreateObject("ADODB.Recordset")
'strSQLSeason = "Select * FROM Seasons WHERE End_Date >= "&TDate&" ORDER BY Start_Date ASC"
StrSeason1 = ""
MyConn.Open(data_source)
strSQLVenue = "Select * FROM Venue WHERE End_Date >= #"&Date()&"# ORDER BY End_Date ASC"
Set rsSQLVenue = MyConn.Execute(strSQLVenue)
if rsSQLVenue.BOF AND rsSQLVenue.EOF then
strVenue = "The cinemobile schedule will be updated shortly"
end if
While not rsSQLVenue.EOF
if x < 1 then
Start_Date = rsSQLVenue("Start_Date")
Start_Day = WeekDay(Start_Date)
End_Date = rsSQLVenue("End_Date")
End_Day = WeekDay(End_Date)
if rsSQLVenue("End_Date") > Date() AND rsSQLVenue("Start_Date") > Date() then
strVenue = "The Cinemobile will be in "& rsSQLVenue("Venue") &", " & rsSQLVenue("County") &" From "&DayName(Start_Day)&", "&DatePart("D",Start_Date)&" "&MonthName(Month(Start_Date))
end if
if rsSQLVenue("Start_Date") <= Date() then
strVenue = "The Cinemobile is in "& rsSQLVenue("Venue") &", " & rsSQLVenue("County") &" Until "&DayName(End_Day)&", "&DatePart("D",End_Date)&" "&MonthName(Month(End_Date))
end if
x = x+1
end if
rsSQLVenue.movenext
wend
rsSQLVenue.Close()
Set rsSQLVenue = nothing
Set strSQLVenue = nothing
intArc = 0
'strSQL = "Select * FROM Calendar WHERE Year ="&Tyear&" AND Month ="&Tmonth&" AND Day ="&Tday&" ORDER BY Times ASC"
strSQL = "Select * FROM Films WHERE Active = True ORDER BY Title Asc"
Set rsSQL = MyConn.Execute(strSQL)
While not rsSQL.EOF
if rsSQL("Picture") = False then
FilmPic = ""
ArcPic = ""
else
FilmPic = " "
ArcPic = "![]() " end if 'if rsSQL("Date") = Date() then 'heading = "Today's Films: "&Tday&" "&MonthName(TMonth)&" "&TYear 'nfilms = nfilms + 1 T_Films = T_Films&" | |
| "&rsSQL("Title")&" | "&FilmPic&" |
| ::Archive Screening:: "&rsSQL("Title")&""
'StrSeason1 = StrSeason1&" "&DayName(weekday(rsSQL("Date")))&", "&DatePart("D",rsSQL("Date"))&" "&MonthName(Month(rsSQL("Date")))&","&rsSQL("Times")&" | "
'StrSeason1 = StrSeason1&""&ArcPic&" |
| From the Archive |
| "&rsSQL("Title")&" "&rsSQL("Date")&" "&rsSQL("Times")&" "&ArcPic&" |
![]() | ![]() |
| <%=strVenue%> | ||||
![]() ![]() ![]() |
|
|||