<%set con = server.createobject("adodb.connection") con.open Datasource set rs = server.createobject("adodb.recordset") set rs10 = server.createobject("adodb.recordset")%>
<%artid=1 set rs = server.createobject("adodb.recordset") set rs1 = server.createobject("adodb.recordset") rs.open "select count(*) from tblartistprofile where aid='"&artid&"'",con mycount=rs(0) rs.close rs1.open "select * from tblartist where aid='"&artid&"'",con%> <% if mycount>0 then rs.open "select * from tblartistprofile where aid='"&artid&"'",con %> <%if rs("description")<>"" then txt=split(rs("description"),"##",-1,1)%> <%else%> <%rs.close end if%> <%else%> <%end if%>
Artist Profile -- <%=rs1("fname")%> <%=rs1("lname")%>
<%rs10.open"select fname, lname,path from tblartist where aid='"&rs("aid")&"'",con If rs10("path")<>"" then%> <%imgs=split(rs10("path"),".",-1,1) imgs1=imgs(0)%> " border="0" > <%End if%> <%rs10.close%>
<%for i=0 to ubound(txt)%>

<%=txt(i)%>


<%next%>
<%edu=split(rs("education"),"##",-1,1) gex=split(rs("gexhibition"),"##",-1,1) solo=split(rs("soloexhibition"),"##",-1,1) awards=split(rs("awards"),"##",-1,1) member=split(rs("member"),"##",-1,1) %> Education :
<%for i=0 to ubound(edu)-1%> <%=i+1%>. <%=edu(i)%>
<%next%>
Group Exhibitions :
<%for i=0 to ubound(gex)-1%> <%=i+1%>. <%=gex(i)%>
<%next%>
Solo Exhibitions :
<%for i=0 to ubound(solo)-1%> <%=i+1%>. <%=solo(i)%>
<%next%>
Awards :
<%for i=0 to ubound(awards)-1%> <%=i+1%>. <%=awards(i)%>
<%next%>
Member of the society :
<%for i=0 to ubound(member)-1%> <%=i+1%>. <%=member(i)%>
<%next%>

Profile not available
   
 
     
<%con.close%>