|
Internationales Jahr der Astronomie 2009
|
Kalendarium für das Internationale
Jahr der Astronomie in der
Europäischen Metropolregion Nürnberg
Änderungen durch die Veranstalter vorbehalten, ohne Gewähr.
Zurück zur Übersicht
<%
Dim strDB, strCon
Dim objCon, objRS
Dim strSQL
IIID = Request.QueryString("IID")
strDB = "Data Source=" & Server.MapPath("../database/iyaterm.mdb")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" & strDB
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open strCon
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "Select * From Orte where Stadt like '" & IIID & "'"
objRS.open strSQL, objCon
Response.Write ""& objRS("Stadt") &""
Do While Not objRS.EOF
Response.Write ""& objRS("Inst") &" "
Response.Write ""& objRS("Bemerkung") &" "
Response.Write " "
objRS.movenext
Loop
Response.Write ""
objRS.Close
Set objRS = Nothing
objCon.Close
Set objCon = Nothing
strDB = "Data Source=" & Server.MapPath("../database/iyaterm.mdb")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" & strDB
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open strCon
Set objRS = Server.CreateObject("ADODB.Recordset")
strSQL = "Select * From Termine where Ort like '" & IIID & "' order by DStart, TStart "
objRS.open strSQL, objCon
Do While Not objRS.EOF
Response.Write ""
Response.Write "| "&WeekdayName(Weekday(objRS("DStart")), True)&", "& Day(objRS("DStart")) & "." & Month(objRS("DStart")) & "."
If IsNull(objRS("DEnde")) = False Then Response.Write " bis " & WeekdayName(Weekday(objRS("DEnde")), True) &", "&Day(objRS("DEnde")) & "." & Month(objRS("DEnde")) & "."
If IsNull(objRS("TStart")) = False Then Response.Write " um "
If IsNull(objRS("TStart")) = False Then Response.Write FormatDateTime(objRS("TStart"), 4) & " Uhr"
If IsNull(objRS("TEnde")) = False Then Response.Write " - " & FormatDateTime(objRS("TEnde"), 4) & " Uhr"
Response.Write " | "
Response.Write "| "& objRS("Bemerkung") &" | "
Response.Write "| | "
objRS.movenext
Loop
objRS.Close
Set objRS = Nothing
objCon.Close
Set objCon = Nothing
Response.Write " "
%>
Zurück zur Übersicht
|
| Webseiten
betreut durch |
 |
|