<% myid = request.querystring("id") set rsalbum = server.createobject("adodb.recordset") sqlalbum = "Select * from albums where ID =" & myid set rs = server.createobject("adodb.recordset") sqlstr = "Select * from songs where albumID =" & myid rsalbum.open sqlalbum, conn, 0, 1 rs.open sqlstr, conn, 0, 1 %> Songs - <%=rsalbum.fields("album")%>

<%=rsalbum.fields("album")%> (<%=rsalbum.fields("year")%>) 

Producer
Director
Music Company
<%=rsalbum.fields("banner") %>
<%=rsalbum.fields("director") %>
<%=rsalbum.fields("company") %>


<% if rs.eof then %>

The song list for the movie is currently in preparation.

<%else%>
<% rs.movefirst do while not rs.eof on error resume next %> <% rs.movenext loop %>
Song Singers Lyricist
<%=rs.fields("song")%> <%=rs.fields("singers")%>  <%=rs.fields("lyricist")%> 
<% end if%>
<% if rsalbum.fields("remarks") > "" then %>

Remarks: <%=rsalbum.fields("remarks") %>

 

<%end if%>


<% rs.close rsalbum.close conn.close set rs=nothing set rsalbum=nothing set conn=nothing %>

Back

_________________________________________
This site is designed, created & maintained by another RDent Fanatic
Vinay P Jain <vpj@bigfoot.com>