<% 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 %>


<%= artistdetail %>