<% band_id = request.querystring("band_id") qry = "select * from bands where band_id = "& band_id &"" set rs = conn.execute(qry) %>
Band

Name :	" size="25">
Message :	<%=rs("band_describe")%>
Logo :	*** (width 200 pixel) ***
	<% if len( rs("band_picture") ) > 0 then response.write imgsrc("../" & rs("band_picture"), rs("band_picturex"), rs("band_picturey"), 200, 0) end if %>
Groups :	<% qryL2 = "select * from groups" set rsL2 = conn.execute(qryL2) sel = "" do while not rsL2.eof if cInt(rsL2("grp_id")) = cInt(rs("grp_id")) then sel = "selected" end if%> " <%=sel%>><%=rsL2("grp_name")%> <% sel = "" rsL2.movenext:loop set rsL2 = nothing %>