Metacat

<%@page import="java.sql.ResultSet"%>

<%@page import="edu.ucsb.nceas.first.metacat.client.AssessmentQuery"%>

<%@page import="java.util.*"%>

<%

String[] docids = request.getParameterValues("docids");

if (docids != null && docids.length > 0) {

	List assessmentDocIds = Arrays.asList(docids);

	//make a title

	String tableTitle = "Showing data for ";

	for (int i=0; i<docids.length; i++) {

		tableTitle += docids[i];

		tableTitle +=", ";

	}

	tableTitle = tableTitle.substring(0, tableTitle.length()-2);

	//AssessmentQuery.testEcogrid("edml.4.5");

	ResultSet rs = AssessmentQuery.selectResponseData(assessmentDocIds);

	int numColumns = rs.getMetaData().getColumnCount();

%>

<!-- <h3><%=tableTitle %></h3> -->

<table>

<!--

<tr>

	<th colspan="<%=numColumns %>"><%=tableTitle %></th>

</tr>

-->

<tr>

<% for (int i=1; i<=numColumns; i++) { %>

	<th><%=rs.getMetaData().getColumnName(i) %></th>

<% } %>

</tr>

<%

while (rs.next()) {

	//System.out.println("rs:" + rs.getInt(1));

%>

	<tr>

<% for (int i=1; i<=numColumns; i++) { %>

		<td><%=rs.getInt(i) %></td>

<% } %>

	</tr>

<%

}

%>

</table>

<%}//end if %>