<%
kod = request.querystring("id")
ssql = "SELECT * FROM ENSTRUMANLAR WHERE ID=" & KOD
set rs = dbconnection.execute(ssql)
ensadi = rs("ADI")
baslik="Eserler (" & ensadi & ")"
%>
<%
ssql2 = "SELECT * FROM ENSTRUMANLAR WHERE ADI='" & ensadi &"'"
set rs2 = dbconnection.execute(ssql2)
while not rs2.eof
ssql = "select ESERID,ENSTRUMANID,ESERADI,ESERLER.AKTIF,ESERLER.ID AS ESID FROM ESERDETAY,ESERLER WHERE ESERLER.AKTIF=0 AND ENSTRUMANID=" & RS2("ID") & " AND ESERDETAY.ESERID = ESERLER.ID order by ESERADI ASC"
set rs = dbconnection.execute(ssql)
while not rs.eof
%>
"> <%=RS("ESERADI")%>
<%
rs.movenext
wend
rs2.movenext
wend
%>