| EVENT
|
VENUE |
DATE |
ORGANISED
AND CONDUCTED BY |
YKKF
International Gasshuku & Symposium in India
(World Championship) |
Venue
not decided |
Feb.
3 to 7, 2011 |
Sensei
Jehangir Shroff (President – YKKF – India) |
<%
set objRsEvn=Server.CreateObject("ADODB.recordset")
objRsEvn.Open "SELECT p_event_id,event_name,venue,Format(sdate,'dd mmm yyyy') as sdate ,Format(edate,'dd mmm yyyy') as edate,org_by FROM events WHERE sdate >= DateSerial(" & Year(Now()) & "," & Month(Now()) & "," & Day(Now()) & ")", objConn,3,3
If Not (objRsEvn.BOF And objRsEvn.EOF) Then
While Not objRsEvn.EOF
Response.Write"| " & objRsEvn("event_name") & " | "
Response.Write"" & objRsEvn("venue") & " | "
If Trim(objRsEvn("edate"))<> "" Then
Response.Write "" & objRsEvn("sdate") & " - " & objRsEvn("edate") & " | "
Else
Response.Write "" & objRsEvn("sdate") & " | "
End If
If Not isNull(objRsEvn("org_by")) Then
Response.Write"" & objRsEvn("org_by") & " | "
Else
Response.Write" | "
End If
objRsEvn.Movenext
Wend
Else
Response.Write(" | No upcoming events. | ")
End If
%>
|
|
