<%@ include file="globalPaths.jsp" %> <%@ include file="globalDefinitions.jsp" %> <%@ include file="cacheBegin.jsp" %> <%@ include file="cacheLaunch.jsp" %> Portfolio, online exhibition <%@ include file="inc/head.txt" %> <%@ include file="inc/top.txt" %> <% Connection connection = null; String artType = null; String category = null; /* * Load database records. */ try { connection = openConnection(); Statement statement = connection.createStatement(); %> <% // AP053008 Removed unwelcome=0 from where. Reason: some artists don't want to be in // our artist listings, yet we need at least one place referring to their account. if (statement.execute("SELECT id, firstName, lastName,login,package,portfolio FROM galleryArtist WHERE activeflag='Y' and package>0 ORDER BY lastName DESC")) { ResultSet resultSet = statement.getResultSet(); while (resultSet.next()) { String portfolio = resultSet.getString("portfolio"); String artist=resultSet.getString("id"); String lastname=resultSet.getString("lastName"); String firstname=resultSet.getString("firstName"); if (resultSet.getString("firstName")==null || "".equals(resultSet.getString("firstName"))) { firstname = ""; } String login=resultSet.getString("login"); int pack=resultSet.getInt("package"); String query = null; Statement statement1=connection.createStatement(); int i=0; query = "SELECT type,category FROM galleryArtwork WHERE artist=" + artist; if (statement1.execute(query)) { ResultSet resultSet1 = statement1.getResultSet(); while (resultSet1.next()&&(i==0)) { category = resultSet1.getString("category"); artType = resultSet1.getString("type"); i++; } resultSet1.close(); } else { //TODO } String uryl="artworks.jsp?artist="+artist; String urylConverted = getURLFilename(uryl, "shtml", null); if (pack == 0 || pack == 1 || pack == 5 || pack == 2 || pack == 3){ // Showroom or OpenStudio //urylConverted = substituteTokens(firstname.substring(0,Math.min(1,firstname.length())).toLowerCase() + lastname.toLowerCase()," ",""); //substituteTokens(firstName.substring(0,1).toLowerCase() + lastName.toLowerCase()," ",""); //urylConverted = login+ ".jsp"; urylConverted = portfolio; } out.print(""); } resultSet.close(); } else { //TODO } } catch(Exception e) { //TODO } finally { if (connection != null && !connection.isClosed()) connection.close(); } %>
 
" //+ firstname + " " //+ lastname + "" + "" + lastname + " " + firstname + "

SELL ART.
ART INVEST.
INVEST IN ART.
ART INVESTMENT.
INVESTMENT ART.
INVESTING IN ART.


"The work of art must seize upon you, wrap you up in itself and carry you away. It is the means by which the artist conveys his passion. It is the current which he puts forth, which sweeps you along in his passion".

"If the painter works directly from nature, he ultimately looks for nothing but momentary effects; he does not try to compose, and soon he gets monotonous."

"In painting, as in the other arts, there's not a single process, no matter how insignificant, which can be reasonably made into a formula. You come to nature with your theories, and she knocks them all flat."

"Shall I tell you what I think are the two qualities of a work of art? First, it must be the indescribable, and second, it must be inimitable."

"An artist, under pain of oblivion, must have confidence in himself, and listen only to his real master: Nature."

Renoir
<%@ include file="inc/bottom.txt" %> <%@ include file="cacheEnd.jsp" %> <%@ include file="globalFinally.jsp" %>