<%@page import="java.sql.ResultSet"%><%@page import="edu.ucsb.nceas.first.metacat.client.AssessmentQuery"%><%@page import="edu.ucsb.nceas.utilities.OrderedMap"%><%@page import="au.com.bytecode.opencsv.CSVWriter"%><%@page import="java.util.*"%><%@page import="java.io.*"%><% String[] docids = request.getParameterValues("docids"); String questionId = request.getParameter("questionId"); String qformat = request.getParameter("qformat"); if (docids != null && docids.length > 0) { List assessmentDocIds = Arrays.asList(docids); //the "columns" to extract from the metadata document (will be param soon) Map attributeMap = new OrderedMap(); attributeMap.put("id", "//@packageId"); attributeMap.put("title", "//assessment/title"); attributeMap.put("duration", "//assessment/duration"); attributeMap.put("badColumn", "//does/not/exist"); attributeMap.put("item", "//assessmentItems/assessmentItem/assessmentItemId"); //make a title String tableTitle = "Showing data for "; String fileName = "results-"; for (int i=0; i"><%=tableTitle %> --> <% for (int i=1; i<=numColumns; i++) { %> <%=rs.getMetaData().getColumnName(i) %> <% } %> <% while (rs.next()) { //System.out.println("rs:" + rs.getInt(1)); %> <% for (int i=1; i<=numColumns; i++) { %> <%=rs.getString(i) %> <% } %> <% } %> <% //clean up if (rs != null) { rs.close(); } }//end if docids else { %> No items selected <%}%>