<%@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
<%}%>