% If Request("id") <> "" And IsNumeric(Request("id")) Then Set Con = Server.CreateObject("Adodb.Connection") Con.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\inetpub\wwwroot\domains\dse-inc.com\seminars.mdb" Set rTemp = Con.Execute("SELECT City, 'Agenda '+Agenda, WE_Date1 FROM Agendas WHERE ID = " & Request("id")) If Not rTemp.EOF Then City = rTemp(0) Agenda = rTemp(1) SeminarDT = rTemp(2) End If rTemp.Close: Set rTemp = Nothing Con.Close: Set Con = Nothing End If %>
| Back |