<%
artistnumber = request.QueryString("artist")
Set rsArtist = Server.CreateObject("ADODB.Recordset")
artistRec = "SELECT * FROM artistdetail WHERE artist_id=" & artistnumber
rsArtist.Open artistRec, dbAgentDat
artistdetail = rsArtist("detail")
Set rsArtistName = Server.CreateObject("ADODB.Recordset")
getArtistName = "SELECT name_display, detail FROM artists WHERE artist_id = " & artistnumber
rsArtistName.Open getArtistName, dbAgentDat
If not rsArtistName.eof then
displayname = rsArtistName("name_display")
currentArtDetail = rsArtistName("detail")
End If
%>
Artist Detail: <%= displayname %>
