<%@ include file="globalPaths.jsp" %><%@ include file="globalDefinitions.jsp" %><% Cookie[] cookies; cookies = request.getCookies(); String cookieArtist = ""; for (int icook = 0; cookies!=null && icook < cookies.length; icook++) { Cookie cookie = cookies[icook]; if ((cookie.getName()).equals("galleryArtistID")) { cookieArtist = cookie.getValue(); } } String remoteIP = "UndefinedIP"; if (request.getRemoteAddr() != null) { remoteIP = request.getRemoteAddr(); } %><% Connection connection = null; Statement statement = null; ResultSet resultSet = null; String query = ""; String artist=null; String url = ""; artist = request.getParameter("artist"); String artistEmail = ""; String artistFirstName = null; if (artist == null || "".equals(artist) || !isInteger(artist)) { session.setAttribute("404.errorDescription", "Incorrect parameter value"); response.sendError(response.SC_NOT_FOUND); return; } boolean err = false; String errorForm = ""; String company=""; String oName=""; String oPlacement=""; String firstlastName=""; String snapshot=""; String email=""; String showEmail=""; String phone=""; String showPhone=""; String website=""; boolean comma = false; Vector opsIds = new Vector(); Vector opsNames = new Vector(); Vector opsStartdates = new Vector(); Vector opsEnddates = new Vector(); Vector opsAddresses = new Vector(); Vector opsDistricts = new Vector(); Vector opsCities = new Vector(); Vector opsStates = new Vector(); Vector opsZips = new Vector(); Vector opsCountries = new Vector(); Vector opsComments = new Vector(); Vector exIds = new Vector(); Vector exNames = new Vector(); Vector exStartdates = new Vector(); Vector exEnddates = new Vector(); Vector exReceptiondates = new Vector(); Vector exAddresses = new Vector(); Vector exAddressComments = new Vector(); Vector exCities = new Vector(); Vector exStates = new Vector(); Vector exZips = new Vector(); Vector exCountries = new Vector(); Vector exComments = new Vector(); Vector woIds = new Vector(); Vector woNames = new Vector(); Vector woStartdates = new Vector(); Vector woEnddates = new Vector(); Vector woReceptiondates = new Vector(); Vector woAddresses = new Vector(); Vector woAddressComments = new Vector(); Vector woCities = new Vector(); Vector woStates = new Vector(); Vector woZips = new Vector(); Vector woCountries = new Vector(); Vector woComments = new Vector(); %><% boolean art = false; boolean career = false; boolean interview = false; boolean booleanFA = false; boolean boolFApai = false; boolean boolFAgra = false; boolean boolFApri = false; boolean boolFApho = false; boolean boolFAscu = false; boolean boolFAmix = false; boolean boolFAnew = false; boolean boolFAins = false; boolean booleanCR = false; boolean boolCRcer = false; boolean boolCRgla = false; boolean boolCRjew = false; boolean boolCRfur = false; boolean boolCRmet = false; boolean boolCRwoo = false; boolean boolCRtex = false; boolean booleanCA = false; boolean boolCAdig = false; boolean boolCAboo = false; boolean boolCAill = false; boolean boolCAcal = false; boolean boolCApri = false; boolean boolCAtyp = false; boolean boolCAweb = false; String pack = null; String showstudio = null; String pack1 = null; String showstudio1 = null; String id = null; String nameOfArtist = null; String seriesL = null; String tip = ""; String wtype = null; String wcategorie = null; boolean isEmpty = false; %><% try { connection = openConnection(); statement = connection.createStatement(); int varTypres = 0; query = "SELECT A.firstName,A.lastName, A.snapshot, A.package, A.activeflag, A.email, A.phone, A.showEmail, A.showPhone, A.website, A.ipLastLoggedFrom, W.id FROM galleryArtist A LEFT JOIN galleryArtwork W ON A.id=W.artist WHERE W.activeflag='Y' AND A.id=" + artist; resultSet = statement.executeQuery(query); if (resultSet.next()) { if (!"admin".equals((String)session.getValue("admin.logged")) && !remoteIP.equals(resultSet.getString("A.ipLastLoggedFrom")) && !artist.equals(cookieArtist)) { if ("N".equals(resultSet.getString("A.activeflag"))) { sendRedirect(globalErrorPage + "?"+"errorDescription=" + URLencode("The pages you are trying to view belong to an account that is not currently activated. If this is a new account, the artist needs to complete the setup process before the artwork will be available on the Internet.")); return; } if ("P".equals(resultSet.getString("A.activeflag"))) { sendRedirect(globalErrorPage + "?"+"errorDescription=" + URLencode("The pages you are trying to view belong to an account that has been closed. Please update your bookmark.")); return; } } if ("0".equals(resultSet.getString("A.package"))) { String wid=resultSet.getString("W.id"); sendRedirect(globalSite+"/artwork.jsp?artwork="+wid); return; } if ("5".equals(resultSet.getString("A.package"))) { sendRedirect(globalErrorPage + "?"+"errorDescription=" + URLencode("Sorry. You have no permission to this page.")); return; } String fn; String ln; fn = resultSet.getString("A.firstName"); ln = resultSet.getString("A.lastName"); if ("".equals(fn.trim())) { firstlastName = toUpperCaseFirstLetter(ln); artistFirstName = firstlastName; } else { firstlastName = toUpperCaseFirstLetter(fn) + " " + toUpperCaseFirstLetter(ln); artistFirstName = toUpperCaseFirstLetter(fn); } snapshot = resultSet.getString("A.snapshot"); email = resultSet.getString("A.email"); showEmail = resultSet.getString("A.showEmail"); phone = resultSet.getString("A.phone"); showPhone = resultSet.getString("A.showPhone"); website = resultSet.getString("A.website"); } resultSet.close(); query = "SELECT OPS.*, OPSA.address, OPSA.comments FROM galleryOpenStudio OPS LEFT JOIN galleryOpenStudioArtist OPA ON OPA.openStudioId=OPS.id LEFT JOIN galleryOpenStudioAddress OPSA ON OPSA.artist=OPA.artist AND OPSA.openStudioId=OPS.id WHERE OPA.artist='" + artist + "' GROUP BY OPS.id ORDER BY OPS.startdate"; resultSet = statement.executeQuery(query); while (resultSet.next()) { opsIds.addElement(resultSet.getString("OPS.id")); opsNames.addElement(resultSet.getString("OPS.name")); if (resultSet.getString("OPSA.address")==null || "".equals(resultSet.getString("OPSA.address"))) { opsAddresses.addElement(resultSet.getString("OPS.placement")); } else { opsAddresses.addElement(resultSet.getString("OPSA.address")); } if (resultSet.getString("OPSA.comments")==null || "".equals(resultSet.getString("OPSA.comments"))) { opsComments.addElement(resultSet.getString("OPS.comments")); } else { opsComments.addElement(resultSet.getString("OPSA.comments")); } opsCities.addElement(resultSet.getString("OPS.city")); opsDistricts.addElement(resultSet.getString("OPS.district")); if (resultSet.getString("OPS.startdate")==null) { opsStartdates.addElement("01/01/1970"); } else { String sd = resultSet.getString("OPS.startdate"); String temp=sd.substring(5,7) + "/" + sd.substring(8,10) + "/" + sd.substring(0,4); opsStartdates.addElement(temp); } if (resultSet.getString("OPS.enddate")==null) { opsEnddates.addElement("01/01/1970"); } else { String ed = resultSet.getString("OPS.enddate"); String temp=ed.substring(5,7) + "/" + ed.substring(8,10) + "/" + ed.substring(0,4); opsEnddates.addElement(temp); } opsStates.addElement(resultSet.getString("OPS.state")); opsCountries.addElement(resultSet.getString("OPS.country")); opsZips.addElement(resultSet.getString("OPS.zip")); } resultSet.close(); query = "SELECT GAE.* FROM galleryArtistExhibition GAE LEFT JOIN galleryArtist A ON A.id=GAE.artist WHERE GAE.flag='1' AND GAE.artist='" + artist + "' ORDER BY GAE.startdate"; resultSet = statement.executeQuery(query); while (resultSet.next()) { exIds.addElement(resultSet.getString("GAE.id")); exNames.addElement(resultSet.getString("GAE.name")); exAddresses.addElement(resultSet.getString("GAE.address")); exCities.addElement(resultSet.getString("GAE.city")); if (resultSet.getString("GAE.startdate")==null) { exStartdates.addElement("01/01/1970"); } else { String sd = resultSet.getString("GAE.startdate"); String temp=sd.substring(5,7) + "/" + sd.substring(8,10) + "/" + sd.substring(0,4); exStartdates.addElement(temp); } if (resultSet.getString("GAE.enddate")==null) { exEnddates.addElement("01/01/1970"); } else { String ed = resultSet.getString("GAE.enddate"); String temp=ed.substring(5,7) + "/" + ed.substring(8,10) + "/" + ed.substring(0,4); exEnddates.addElement(temp); } if (resultSet.getString("GAE.receptiondate")==null) { exReceptiondates.addElement("01/01/1970"); } else { String sd = resultSet.getString("GAE.receptiondate"); String temp=sd.substring(5,7) + "/" + sd.substring(8,10) + "/" + sd.substring(0,4); exReceptiondates.addElement(temp); } exStates.addElement(resultSet.getString("GAE.state")); exCountries.addElement(resultSet.getString("GAE.country")); exZips.addElement(resultSet.getString("GAE.zip")); exComments.addElement(resultSet.getString("GAE.comments")); exAddressComments.addElement(resultSet.getString("GAE.addressComments")); } resultSet.close(); query = "SELECT GAE.* FROM galleryArtistExhibition GAE LEFT JOIN galleryArtist A ON A.id=GAE.artist WHERE GAE.flag='0' AND GAE.artist='" + artist + "' ORDER BY GAE.startdate"; resultSet = statement.executeQuery(query); while (resultSet.next()) { woIds.addElement(resultSet.getString("GAE.id")); woNames.addElement(resultSet.getString("GAE.name")); woAddresses.addElement(resultSet.getString("GAE.address")); woCities.addElement(resultSet.getString("GAE.city")); if (resultSet.getString("GAE.startdate")==null) { woStartdates.addElement("01/01/1970"); } else { String sd = resultSet.getString("GAE.startdate"); String temp=sd.substring(5,7) + "/" + sd.substring(8,10) + "/" + sd.substring(0,4); woStartdates.addElement(temp); } if (resultSet.getString("GAE.enddate")==null) { woEnddates.addElement("01/01/1970"); } else { String ed = resultSet.getString("GAE.enddate"); String temp=ed.substring(5,7) + "/" + ed.substring(8,10) + "/" + ed.substring(0,4); woEnddates.addElement(temp); } if (resultSet.getString("GAE.receptiondate")==null) { woReceptiondates.addElement("01/01/1970"); } else { String sd = resultSet.getString("GAE.receptiondate"); String temp=sd.substring(5,7) + "/" + sd.substring(8,10) + "/" + sd.substring(0,4); woReceptiondates.addElement(temp); } woStates.addElement(resultSet.getString("GAE.state")); woCountries.addElement(resultSet.getString("GAE.country")); woZips.addElement(resultSet.getString("GAE.zip")); woComments.addElement(resultSet.getString("GAE.comments")); woAddressComments.addElement(resultSet.getString("GAE.addressComments")); } resultSet.close(); query = "SELECT DISTINCT type, category FROM galleryArtwork " + " WHERE (activeflag='Y' OR activeflag='L') AND artist=" + artist; resultSet = statement.executeQuery(query); while (resultSet.next()) { wtype=resultSet.getString("type"); wcategorie=resultSet.getString("category"); if (wtype.equals("fineart")) { booleanFA = true; if (wcategorie.equals("painting")) { boolFApai = true; } if (wcategorie.equals("photography")) { boolFApho = true; } if (wcategorie.equals("printmaking")) { boolFApri = true; } if (wcategorie.equals("sculpture")) { boolFAscu = true; } if (wcategorie.equals("graphics")) { boolFAgra = true; } if (wcategorie.equals("mixedmedia")) { boolFAmix = true; } if (wcategorie.equals("newmedia")) { boolFAnew = true; } if (wcategorie.equals("installationart")) { boolFAins = true; } } if (wtype.equals("craft")) { booleanCR = true; if (wcategorie.equals("ceramics")) { boolCRcer = true; } if (wcategorie.equals("glass")) { boolCRgla = true; } if (wcategorie.equals("jewelry")) { boolCRjew = true; } if (wcategorie.equals("furniture")) { boolCRfur = true; } if (wcategorie.equals("metalart")) { boolCRmet = true; } if (wcategorie.equals("wood")) { boolCRwoo = true; } if (wcategorie.equals("textile")) { boolCRtex = true; } } if (wtype.equals("commercialart")) { booleanCA = true; if (wcategorie.equals("illustration")) { boolCAill = true; } if (wcategorie.equals("booksart")) { boolCAboo = true; } if (wcategorie.equals("calligraphy")) { boolCAcal = true; } if (wcategorie.equals("printdesign")) { boolCApri = true; } if (wcategorie.equals("webdesign")) { boolCAweb = true; } if (wcategorie.equals("typography")) { boolCAtyp = true; } } } resultSet.close(); } catch(Exception e) { errorLog(e, query); sendRedirect(globalErrorPage + "?errorDescription=" + URLEncoder.encode(e.getMessage() + ".")); return; } finally { if (resultSet != null) resultSet.close(); if (connection != null && !connection.isClosed()) connection.close(); } %> <%= firstlastName %>'s Calendar <%@ include file="inc/head.txt" %> <%@ include file="inc/top.txt" %>
  <% if (booleanFA) { %> <% } %> <% if (booleanCR) { %> <% } %> <% if (booleanCA) { %> <% } %>
  FINE ART:  <% if (boolFApai) { out.print("Painting"); comma = true; } if (boolFAgra) { if (comma) out.print(", "); out.print("Graphics"); comma = true; } if (boolFApri) { if (comma) out.print(", "); out.print("Printmaking"); comma = true; } if (boolFApho) { if (comma) out.print(", "); out.print("Photography"); comma = true; } if (boolFAscu) { if (comma) out.print(", "); out.print("Sculpture"); comma = true; } if (boolFAmix) { if (comma) out.print(", "); out.print("Mixed Media  "); comma = true; } if (boolFAnew) { if (comma) out.print(", "); out.print("New Media"); comma = true; } if (boolFAins) { if (comma) out.print(", "); out.print("Installation Art  "); } comma = false; %>
  CRAFT:  <% if (boolCRcer) { out.print("Ceramics"); comma = true; } if (boolCRgla) { if (comma) out.print(", "); out.print("Glass"); comma = true; } if (boolCRjew) { if (comma) out.print(", "); out.print("Jewelry"); comma = true; } if (boolCRfur) { if (comma) out.print(", "); out.print("Furniture"); comma = true; } if (boolCRmet) { if (comma) out.print(", "); out.print("Metal Art"); comma = true; } if (boolCRwoo) { if (comma) out.print(", "); out.print("Wood"); comma = true; } if (boolCRtex) { if (comma) out.print(", "); out.print("Fiber Art"); } comma = false; %>
  GRAPHIC DESIGN:  <% if (boolCAboo) { out.print("Book Art"); comma = true; } if (boolCAill) { if (comma) out.print(", "); out.print("Illustration"); comma = true; } if (boolCAcal) { if (comma) out.print(", "); out.print("Calligraphy"); comma = true; } if (boolCApri) { if (comma) out.print(", "); out.print("Print Design"); comma = true; } if (boolCAtyp) { if (comma) out.print(", "); out.print("Typography"); comma = true; } if (boolCAweb) { if (comma) out.print(", "); out.print("Web Design"); } %>
<% if (err) { %> <% } %>
 
Error:  <%= errorForm %>
 
border=0 alt="Inquire" width="139">
  <% out.print(firstlastName); %><% %><% if (!"".equals(company.trim())) { %>

   <%=company%><% } %>
 
          Artworks
          Biography
          Guestbook
 
 
<% if (opsIds.size() > 0) { %> <% for (int i=0; i < opsIds.size(); i++) { %> <% if (i>0) { %> <% } %> <% if ((String)opsComments.elementAt(i)!=null && !"".equals((String)opsComments.elementAt(i))) { %> <% } %> <% } } %> <% if (exIds.size() > 0) { %> <% for (int i=0; i < exIds.size(); i++) { %> <% if (i>0) { %> <% } %> <% if ((String)exComments.elementAt(i)!=null && !"".equals((String)exComments.elementAt(i))) { %> <% } %> <% } } %> <% if (woIds.size() > 0) { %> <% for (int i=0; i < woIds.size(); i++) { %> <% if (i>0) { %> <% } %> <% if ((String)woComments.elementAt(i)!=null && !"".equals((String)woComments.elementAt(i))) { %> <% } %> <% } } %> <% if ((!website.equals(""))||(!email.equals(""))||(!phone.equals(""))) { %> <% } %>
    <% out.print(firstlastName); %>'s Calendar of Art Events
 Open Studios    Day & Time   Studio Address Map
   
 
<% if ("East Bay Open Studios (Pro Arts)".equals((String)opsNames.elementAt(i))) { out.print("Pro Arts
East Bay
OPS"); } else { if ("San Francisco OPS".equals((String)opsNames.elementAt(i))) { out.print("San Francisco
OPS"); } else { out.print((String)opsNames.elementAt(i)); } } %>
 
  <% if (!"01/01/1970".equals(opsEnddates.elementAt(i))) { String dateString = ""; String stday = ((String)opsStartdates.elementAt(i)).substring(3,5); if ("0".equals(stday.substring(0,1))) stday = stday.substring(1,2); String enday = ((String)opsEnddates.elementAt(i)).substring(3,5); if ("0".equals(enday.substring(0,1))) enday = enday.substring(1,2); String stmonth = ((String)opsStartdates.elementAt(i)).substring(0,2); if ("0".equals(stmonth.substring(0,1))) stmonth = stmonth.substring(1,2); if ("1".equals(stmonth)) stmonth = "January"; if ("2".equals(stmonth)) stmonth = "February"; if ("3".equals(stmonth)) stmonth = "March"; if ("4".equals(stmonth)) stmonth = "April"; if ("5".equals(stmonth)) stmonth = "May"; if ("6".equals(stmonth)) stmonth = "June"; if ("7".equals(stmonth)) stmonth = "July"; if ("8".equals(stmonth)) stmonth = "August"; if ("9".equals(stmonth)) stmonth = "September"; if ("10".equals(stmonth)) stmonth = "October"; if ("11".equals(stmonth)) stmonth = "November"; if ("12".equals(stmonth)) stmonth = "December"; String enmonth = ((String)opsEnddates.elementAt(i)).substring(0,2); if ("0".equals(enmonth.substring(0,1))) enmonth = enmonth.substring(1,2); if ("1".equals(enmonth)) enmonth = "January"; if ("2".equals(enmonth)) enmonth = "February"; if ("3".equals(enmonth)) enmonth = "March"; if ("4".equals(enmonth)) enmonth = "April"; if ("5".equals(enmonth)) enmonth = "May"; if ("6".equals(enmonth)) enmonth = "June"; if ("7".equals(enmonth)) enmonth = "July"; if ("8".equals(enmonth)) enmonth = "August"; if ("9".equals(enmonth)) enmonth = "September"; if ("10".equals(enmonth)) enmonth = "October"; if ("11".equals(enmonth)) enmonth = "November"; if ("12".equals(enmonth)) enmonth = "December"; String styear = ((String)opsStartdates.elementAt(i)).substring(6,10); String enyear = ((String)opsEnddates.elementAt(i)).substring(6,10); if (enyear.equals(styear)) { //2004=2004 if (enmonth.equals(stmonth)) { //january=january dateString = stmonth+" "+stday+" - "+enday+", "+styear; } else { //january!=june dateString = stmonth+" "+stday+" - "+enmonth+" "+enday+", "+styear; } } else { //2004!=2005 dateString = stmonth+" "+stday+", "+styear+" - "+enmonth+" "+enday+", "+enyear; } out.print(dateString); } %>
<% if (opsAddresses.elementAt(i)!=null) { url = "http://maps.yahoo.com/py/maps.py?Pyt=Tmap&"; if (!"".equals(opsAddresses.elementAt(i))) { url += "desc="+ substituteTokens(firstlastName+"-"+(String)opsNames.elementAt(i), " ", "+"); String tempo = substituteTokens((String)opsAddresses.elementAt(i), " ", "+") ; tempo = substituteTokens(tempo, "\"", "\'"); tempo = substituteTokens(tempo, " ", ""); url += "&addr="+tempo; out.print(opsAddresses.elementAt(i)+"
"); } if (!"".equals(opsDistricts.elementAt(i))) { out.print(opsDistricts.elementAt(i)+"
"); } if (!"".equals(opsCities.elementAt(i))) { url += "&city="+substituteTokens((String)opsCities.elementAt(i), " ", "+"); out.print(opsCities.elementAt(i)); } if (!"".equals(opsStates.elementAt(i))) { url += "&state="+substituteTokens((String)opsStates.elementAt(i), " ", "+"); out.print(", "+opsStates.elementAt(i)); } if (!"".equals(opsZips.elementAt(i))) { url += "&zip="+substituteTokens((String)opsZips.elementAt(i), " ", "+"); out.print(" "+opsZips.elementAt(i)); } if (!"".equals(opsCountries.elementAt(i)) && !"US".equals(opsCountries.elementAt(i)) ) { if ( "Canada".equals(opsCountries.elementAt(i))) { url += "&country=ca"; } out.print("
"+opsCountries.elementAt(i)); } else { if ( "US".equals(opsCountries.elementAt(i))) { url += "&country=us"; } else { url = null; } } } %>
<% if ("US".equals(opsCountries.elementAt(i)) || "Canada".equals(opsCountries.elementAt(i))) { if (opsAddresses.elementAt(i)!=null && url != null) { %>[ Map]<% } } %>
 
 
  <%= convertHTMLSymbolsToPlainNew((String)opsComments.elementAt(i)) %>
 
 
 
 Exhibitions      
   
 
<%= (String)exNames.elementAt(i) %> 
  <% //out.print("start date::"+(String)exStartdates.elementAt(i)+"
"); if (!"01/01/1970".equals(exEnddates.elementAt(i))) { String dateString = ""; String stday = ((String)exStartdates.elementAt(i)).substring(3,5); if ("0".equals(stday.substring(0,1))) stday = stday.substring(1,2); //out.print("stday::"+stday+"
"); String enday = ((String)exEnddates.elementAt(i)).substring(3,5); if ("0".equals(enday.substring(0,1))) enday = enday.substring(1,2); //out.print("enday::"+enday+"
"); String stmonth = ((String)exStartdates.elementAt(i)).substring(0,2); if ("0".equals(stmonth.substring(0,1))) stmonth = stmonth.substring(1,2); //out.print("stmonth::"+stmonth+"
"); if ("1".equals(stmonth)) stmonth = "January"; if ("2".equals(stmonth)) stmonth = "February"; if ("3".equals(stmonth)) stmonth = "March"; if ("4".equals(stmonth)) stmonth = "April"; if ("5".equals(stmonth)) stmonth = "May"; if ("6".equals(stmonth)) stmonth = "June"; if ("7".equals(stmonth)) stmonth = "July"; if ("8".equals(stmonth)) stmonth = "August"; if ("9".equals(stmonth)) stmonth = "September"; if ("10".equals(stmonth)) stmonth = "October"; if ("11".equals(stmonth)) stmonth = "November"; if ("12".equals(stmonth)) stmonth = "December"; String enmonth = ((String)exEnddates.elementAt(i)).substring(0,2); if ("0".equals(enmonth.substring(0,1))) enmonth = enmonth.substring(1,2); //out.print("enmonth::"+enmonth+"
"); if ("1".equals(enmonth)) enmonth = "January"; if ("2".equals(enmonth)) enmonth = "February"; if ("3".equals(enmonth)) enmonth = "March"; if ("4".equals(enmonth)) enmonth = "April"; if ("5".equals(enmonth)) enmonth = "May"; if ("6".equals(enmonth)) enmonth = "June"; if ("7".equals(enmonth)) enmonth = "July"; if ("8".equals(enmonth)) enmonth = "August"; if ("9".equals(enmonth)) enmonth = "September"; if ("10".equals(enmonth)) enmonth = "October"; if ("11".equals(enmonth)) enmonth = "November"; if ("12".equals(enmonth)) enmonth = "December"; String styear = ((String)exStartdates.elementAt(i)).substring(6,10); String enyear = ((String)exEnddates.elementAt(i)).substring(6,10); if (enyear.equals(styear)) { //2004=2004 if (enmonth.equals(stmonth)) { //january=january dateString = stmonth+" "+stday+" - "+enday+", "+styear; } else { //january!=june dateString = stmonth+" "+stday+" - "+enmonth+" "+enday+", "+styear; } } else { //2004!=2005 dateString = stmonth+" "+stday+", "+styear+" - "+enmonth+" "+enday+", "+enyear; } out.print(dateString); } %>
<% if (exAddresses.elementAt(i)!=null && !"".equals((String)exAddresses.elementAt(i))) { url = "http://maps.yahoo.com/py/maps.py?Pyt=Tmap&"; if (!"".equals(exAddresses.elementAt(i))) { url += "desc="+ substituteTokens(firstlastName+"-"+(String)exNames.elementAt(i), " ", "+"); String tempo = substituteTokens((String)exAddresses.elementAt(i), " ", "+") ; tempo = substituteTokens(tempo, "\"", "\'"); url += "&addr="+tempo; out.print(exAddresses.elementAt(i)+"
"); } if (!"".equals(exCities.elementAt(i))) { out.print(exCities.elementAt(i)); url += "&city="+substituteTokens((String)exCities.elementAt(i), " ", "+"); } if (!"".equals(exStates.elementAt(i))) { out.print(", "+exStates.elementAt(i)); url += "&state="+substituteTokens((String)exStates.elementAt(i), " ", "+"); } if (!"".equals(exZips.elementAt(i))) { url += "&zip="+substituteTokens((String)exZips.elementAt(i), " ", "+"); out.print(" "+exZips.elementAt(i)); } if (!"".equals(exCountries.elementAt(i)) && !"US".equals(exCountries.elementAt(i)) ) { if ( "Canada".equals(exCountries.elementAt(i))) { url += "&country=ca"; } out.print("
"+exCountries.elementAt(i)); } else { if ( "US".equals(exCountries.elementAt(i))) { url += "&country=us"; } else { url = null; } } } %>
<% if ("US".equals(exCountries.elementAt(i)) || "Canada".equals(exCountries.elementAt(i))) { if (exAddresses.elementAt(i)!=null && !"".equals((String)exAddresses.elementAt(i))) { %>[ Map]<% } } %>
 
 
  <%= convertHTMLSymbolsToPlainNew((String)exComments.elementAt(i)) %>
 
 
 Workshops      
   
 
<%= (String)woNames.elementAt(i) %> 
  <% //out.print((String)exStartdates.elementAt(i)); if (!"01/01/1970".equals(woEnddates.elementAt(i))) { String dateString = ""; String stday = ((String)woStartdates.elementAt(i)).substring(3,5); if ("0".equals(stday.substring(0,1))) stday = stday.substring(1,2); String enday = ((String)woEnddates.elementAt(i)).substring(3,5); if ("0".equals(enday.substring(0,1))) enday = enday.substring(1,2); String stmonth = ((String)woStartdates.elementAt(i)).substring(0,2); if ("0".equals(stmonth.substring(0,1))) stmonth = stmonth.substring(1,2); if ("1".equals(stmonth)) stmonth = "January"; if ("2".equals(stmonth)) stmonth = "February"; if ("3".equals(stmonth)) stmonth = "March"; if ("4".equals(stmonth)) stmonth = "April"; if ("5".equals(stmonth)) stmonth = "May"; if ("6".equals(stmonth)) stmonth = "June"; if ("7".equals(stmonth)) stmonth = "July"; if ("8".equals(stmonth)) stmonth = "August"; if ("9".equals(stmonth)) stmonth = "September"; if ("10".equals(stmonth)) stmonth = "October"; if ("11".equals(stmonth)) stmonth = "November"; if ("12".equals(stmonth)) stmonth = "December"; String enmonth = ((String)woEnddates.elementAt(i)).substring(0,2); if ("0".equals(enmonth.substring(0,1))) enmonth = enmonth.substring(1,2); if ("1".equals(enmonth)) enmonth = "January"; if ("2".equals(enmonth)) enmonth = "February"; if ("3".equals(enmonth)) enmonth = "March"; if ("4".equals(enmonth)) enmonth = "April"; if ("5".equals(enmonth)) enmonth = "May"; if ("6".equals(enmonth)) enmonth = "June"; if ("7".equals(enmonth)) enmonth = "July"; if ("8".equals(enmonth)) enmonth = "August"; if ("9".equals(enmonth)) enmonth = "September"; if ("10".equals(enmonth)) enmonth = "October"; if ("11".equals(enmonth)) enmonth = "November"; if ("12".equals(enmonth)) enmonth = "December"; String styear = ((String)woStartdates.elementAt(i)).substring(6,10); String enyear = ((String)woEnddates.elementAt(i)).substring(6,10); if (enyear.equals(styear)) { //2004=2004 if (enmonth.equals(stmonth)) { //january=january dateString = stmonth+" "+stday+" - "+enday+", "+styear; } else { //january!=june dateString = stmonth+" "+stday+" - "+enmonth+" "+enday+", "+styear; } } else { //2004!=2005 dateString = stmonth+" "+stday+", "+styear+" - "+enmonth+" "+enday+", "+enyear; } out.print(dateString); } %>
<% if (woAddresses.elementAt(i)!=null && !"".equals((String)woAddresses.elementAt(i))) { url = "http://maps.yahoo.com/py/maps.py?Pyt=Tmap&"; if (!"".equals(woAddresses.elementAt(i))) { url += "desc="+ substituteTokens(firstlastName+"-"+(String)woNames.elementAt(i), " ", "+"); String tempo = substituteTokens((String)woAddresses.elementAt(i), " ", "+") ; tempo = substituteTokens(tempo, "\"", "\'"); url += "&addr="+tempo; out.print(woAddresses.elementAt(i)+"
"); } if (!"".equals(woCities.elementAt(i))) { out.print(woCities.elementAt(i)); url += "&city="+substituteTokens((String)woCities.elementAt(i), " ", "+"); } if (!"".equals(woStates.elementAt(i))) { out.print(", "+woStates.elementAt(i)); url += "&state="+substituteTokens((String)woStates.elementAt(i), " ", "+"); } if (!"".equals(woZips.elementAt(i))) { url += "&zip="+substituteTokens((String)woZips.elementAt(i), " ", "+"); out.print(" "+woZips.elementAt(i)); } if (!"".equals(woCountries.elementAt(i)) && !"US".equals(woCountries.elementAt(i)) ) { if ( "Canada".equals(woCountries.elementAt(i))) { url += "&country=ca"; } out.print("
"+woCountries.elementAt(i)); } else { if ( "US".equals(woCountries.elementAt(i))) { url += "&country=us"; } else { url = null; } } } %>
<% if ("US".equals(woCountries.elementAt(i)) || "Canada".equals(woCountries.elementAt(i))) { if (woAddresses.elementAt(i)!=null && !"".equals((String)woAddresses.elementAt(i))) { %>[ Map]<% } } %>
 
 
  <%= convertHTMLSymbolsToPlainNew((String)woComments.elementAt(i)) %>
 
 
 
<% if ((!("".equals(email)))||(!("".equals(phone)))) { %> <% if (((showEmail.equals("1")))||((showPhone.equals("1")))) { %> <% } } %> <% if (!website.equals("")) { %> <% } %>
<%= artistFirstName %>'s Contact Information:    click here
<%= artistFirstName %>'s Website    ><%= website %>
<%@ include file="inc/bottom.txt" %> <%@ include file="globalFinally.jsp" %>