<% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; int res_pg = (request.getParameter("num") == null)? 10: Integer.parseInt(request.getParameter("num").toString()); // // Get a connection to the database // DatabaseAdapter db = new DatabaseAdapter("ciesin.sdwdb.webss"); db.initConnection(); Connection conn = db.getConnection(); // various queries to populate pulldowns String year_q = "select unique Substr(t.year, 1, 4)YEAR from envtreatycop t ORDER BY YEAR"; String cop_q = "select UNIQUE t.cop from webss.envtreatycop t WHERE t.cop IS NOT NULL ORDER BY cop"; String decision_q = "select UNIQUE t.decision from webss.envtreatycop t WHERE t.decision IS NOT NULL ORDER BY decision"; String conv_q = "select UNIQUE t.convention from webss.envtreatycop t WHERE t.convention IS NOT NULL ORDER BY convention"; String resolut_q = "select UNIQUE t.resolution from webss.envtreatycop t WHERE t.resolution IS NOT NULL ORDER BY resolution"; String recomm_q = "select UNIQUE t.recomm from webss.envtreatycop t WHERE t.recomm IS NOT NULL ORDER BY recomm"; String annex_q = "select UNIQUE t.annex from webss.envtreatycop t WHERE t.annex IS NOT NULL ORDER BY annex"; Statement st = conn.createStatement(); ResultSet rset = null; boolean more; st = conn.createStatement(); %>