<%@ include file="globalPaths.jsp" %> <%@ include file="globalDefinitions.jsp" %> <%@ include file="inc/states.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 id = null; Vector names = new Vector(); Vector lastNames = new Vector(); Vector ids = new Vector(); Vector countries = new Vector(); Vector techniques = new Vector(); Vector themes = new Vector(); Vector styles = new Vector(); try { connection = openConnection(); statement = connection.createStatement(); query = "SELECT lastName, firstName, id" + " FROM galleryArtist WHERE package IN (1,2,5,3) AND (activeflag='Y' OR id=" + quoteString(cookieArtist) + " OR ipLastLoggedFrom=" + quoteString(remoteIP) + ") AND unwelcome<=1 ORDER BY lastName"; resultSet = statement.executeQuery(query); String lastId = null; String fullName; String firstName; String lastName; while (resultSet.next()) { firstName = resultSet.getString("firstName"); lastName = resultSet.getString("lastName"); if (firstName.equals("")) fullName = lastName; else fullName = lastName + ", " + firstName; ids.addElement(resultSet.getString("id")); names.addElement(fullName); lastNames.addElement(lastName); } resultSet.close(); query = "SELECT DISTINCT country FROM galleryArtist WHERE (activeflag='Y' OR id=" + quoteString(cookieArtist) + " OR ipLastLoggedFrom=" + quoteString(remoteIP) + ")" + " order by country='Other', country"; resultSet = statement.executeQuery(query); while (resultSet.next()) { countries.addElement(resultSet.getString("country")); } resultSet.close(); query = "SELECT name FROM gallerySearchOption" + " WHERE type='technique' ORDER BY name"; resultSet = statement.executeQuery(query); while (resultSet.next()) { techniques.addElement(resultSet.getString("name")); } resultSet.close(); query = "SELECT name FROM gallerySearchOption" + " WHERE type='style' ORDER BY name"; resultSet = statement.executeQuery(query); while (resultSet.next()) { styles.addElement(resultSet.getString("name")); } resultSet.close(); query = "SELECT name FROM gallerySearchOption" + " WHERE type='theme' ORDER BY name"; resultSet = statement.executeQuery(query); while (resultSet.next()) { themes.addElement(resultSet.getString("name")); } resultSet.close(); } catch(Exception e) { errorLog(e, query); sendRedirect(globalErrorPage + "?errorDescription=" + URLEncoder.encode(e.toString() + ".")); return; } finally { if (resultSet != null) resultSet.close(); if (connection != null && !connection.isClosed()) connection.close(); } %> <%@ include file="inc/head.txt" %> <%@ include file="inc/top.txt" %>

Art Search     To search by one field, select it and click "Go". To search by several fields, select one or more boxes and click "Combined Search".   Category    Any category Painting Graphics Printmaking Photography Sculpture Mixed Media New Media Ceramics Glass Jewelry Furniture Fiber Art/Textile Book Art Calligraphy Illustration Print Design Typography Web Design     Theme    Any theme <% for (int i=0; i" + ((String)themes.elementAt(i)) + ""); } %> Other     Keyword             Style    Any style <% for (int i=0; i" + ((String)styles.elementAt(i)) + ""); } %> Other          Medium    Any medium <% for (int i=0; i" + ((String)techniques.elementAt(i)).substring(0,1).toUpperCase() + ((String)techniques.elementAt(i)).substring(1) + ""); } %> Other          Color    Any Color Mixed White Black Yellow Blue Green Brown Purple Cyan Magenta Red Khaki Orange Gray Pink          Size    Any size Small (Each side < 40") Medium (Side > 40") Large (Side > 60")          Country    Any Country <% for (int i = 0; i < countries.size(); i++) { %> <%= (String)countries.elementAt(i) %> <% } %>          Price    Minimum Price, US$        Maximum Price, US$    Include Not Priced    Artist    Any Artist <% for (int i = 0; i < names.size(); i++) { %> "><%= (String)names.elementAt(i) %> <% } %>     Artist's State    Any State <% for (int i = 0; i < statesCodes.length; i++) { out.println("" + statesNames[i] + ""); } %>                  Artist Listing  A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z

<%@ include file="inc/bottom.txt" %> <% names.removeAllElements(); lastNames.removeAllElements(); ids.removeAllElements(); countries.removeAllElements(); techniques.removeAllElements(); themes.removeAllElements(); styles.removeAllElements(); %> <%@ include file="globalFinally.jsp" %>