<%
dim title
title = "MayorSlay.com - Podcasts"
dim desc
desc = "Official Website of Mayor Francis Slay - About Mayor Slay"
dim keywords
keywords = "Mayor Slay, Francis Slay, St. Louis Mayor, St. Louis, Mayor Slay, City of St. Louis, Missouri, Podcasts, podcasting, mp3s, audio"
dim section
section = "Podcasts"
%>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/Data/podcast.mdb"))
AID=Request.QueryString("podID")
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM pods WHERE podID="& AID &""
rs.Open sql, conn
%>
<% Response.Write(rs("podDay").Value) %>, <% Response.Write(rs("podMonth").Value) %> <% Response.Write(rs("podDate").Value) %>, <% Response.Write(rs("podYear").Value) %>
<% Response.Write(rs("Header").Value) %> ">
<% Response.Write(rs("Blurb").Value) %>
Download and Listen to this Podcast: "><% Response.Write(rs("podLink").Value) %>