 TABLE
OF CONTENTS |
 |
<%
sSQL = "SELECT nPressReleaseID, sTitle, sHeadline, dDate from tbPressReleases "
sSQL = sSQL & "WHERE datepart(Yy,dDate) = " & nSelectedYear
sSQL = sSQL & "ORDER BY dDate desc "
set rsPress = server.createobject("adodb.recordset")
rsPress.open sSQL, Application("Appleton"),0,1
while not rsPress.eof
nPressReleaseID = rsPress("nPressReleaseID")
sTitle = rsPress("sTitle")
sHeadline = rsPress("sHeadline") & ""
dDate = rsPress("dDate")
sDate = monthname(datepart("m",dDate)) & " " & datepart("d",dDate) & ", " & datepart("yyyy",dDate)
%>
|
Appleton Liquidtight Cable and Conduit Connectors
Now available pre-assembled with a KO Sealing Ring |
|
|
Appleton Brand
See our breadth of line |
|
|
Induction Lighting
The perfect location for Induction Lighting
|
|
|
CodeMaster 2 QL Lighting
100,000 hours of virtually maintenance-free operation |
|
<%
rsPress.movenext
wend
rsPress.close
set rsPress = nothing
%>
|
|
