<% PageName = "records" %> <% sql = "SELECT * FROM T_ALBUMS ORDER BY ALBUM_DISPLAY_ORDER" set rs = conn.execute(sql) ALBUM_ID = s2n(Request.QueryString("ALBUM_ID")) %>
<%if not rs.EOF then%> <%do while not rs.EOF%> <%rs.movenext() loop%>
<%if atrim(rs("ALBUM_COVER").value)<> "" then%>" border=0 width="100" height="100"><%end if%> <%=atrim(rs("album_TITLE").value)%>
<%=atrim(rs("album_ARTIST").value)%>

<%=year(atrim(rs("album_YEAR").value))%>
<%if atrim(rs("ALBUM_BY_IT_LINK").value)<> "" and atrim(rs("ALBUM_BY_IT_LINK_TITLE").value) <>"" then%>"><%=atrim(rs("ALBUM_BY_IT_LINK_TITLE").value) %><%end if%>
">more...
<%end if %>
<% if ALBUM_ID <> 0 then sql = "SELECT * FROM T_ALBUMS WHERE ALBUM_ID="& ALBUM_ID set rs = conn.execute(sql) if not rs.eof then %>


<%=atrim(rs("ALBUM_DESCRIPTION").value) %>

<%=atrim(rs("ALBUM_SONGS").value) %>
<% end if else %>

" border="0">
<%end if%>