% Sub Page_Body()
If request("ID") <> "" Then
sql = "SELECT * FROM news WHERE ID = " & SQLQuotes(request("ID")) & ""
Else
sql = "SELECT * FROM news WHERE show_article = 1 AND is_bicycle = 0 ORDER BY article_date DESC"
End If
set rs = server.createobject("adodb.recordset")
rs.open sql, conn
If rs.eof Then
response.write "
Sorry, there are currently no News articles for viewing.
"
Exit Sub
End If
%>
|
<% If rs("file_path") <> "" Then %>
<%=rs("title")%> |
|
|
<% If rs("text") <> "" Then response.write replace(rs("text"),vbcrlf," |
"><%= rs("title") %>
<%= rs("article_date") %>