<%@LANGUAGE="JAVASCRIPT"%>
<%
var CONNECT_STRING = "Data Source=sqlb15;provider=SQLOLEDB;Network Library=DBMSSOCN;Initial Catalog=gacycling;UID=molyneauxt;pwd=eriktyler1"
var eventlist = Server.CreateObject("ADODB.Recordset");
var ConnectObj = Server.CreateObject("ADODB.Connection");
ConnectObj.open(CONNECT_STRING);
eventlist.ActiveConnection = ConnectObj;
eventlist.Source = "SELECT CycleEvents.EV_ID, CycleEvents.EV_Name, EventStages.ES_City, convert(varchar(10),EventStages.ES_Date,101) As ES_Date FROM CycleEvents LEFT OUTER JOIN EventStages ON CycleEvents.EV_ID = EventStages.ES_EventID WHERE ES_Date >= '7/1/2008' ORDER BY ES_Date";
eventlist.CursorType = 0;
eventlist.CursorLocation = 2;
eventlist.LockType = 1;
eventlist.Open();
var LastEvent = -1;
%>
|
|
| Race Day Countdown: Gwinnett Bike Fest!
|
<%eventlist.close();%>
<%ConnectObj.Close();%>
© 2009 Copyright FloridaCycling.com - All rights reserved.
Owned and Operated by TOPVIEW Sports LLC.
