[Ils-source] r1297 - trunk/webapp

[scribe at crosswire.org]

Author: scribe
Date: 2015-01-13 17:04:28 -0700 (Tue, 13 Jan 2015)
New Revision: 1297

Modified:
   trunk/webapp/SQL.jsp
Log:
added better output for export


Modified: trunk/webapp/SQL.jsp
===================================================================
--- trunk/webapp/SQL.jsp	2015-01-14 00:00:19 UTC (rev 1296)
+++ trunk/webapp/SQL.jsp	2015-01-14 00:04:28 UTC (rev 1297)
@@ -714,8 +714,7 @@
 		   e1.printStackTrace();
 	      }
 	      if (errOut != null) {
-	          errOut.write("<table border=\"1\"> <tr> <th>Executing SQL</th> <td>"
-	          + testSQL + "</td> </tr>");
+	          errOut.write("<table border=\"1\"> <tr> <th>Executing SQL</th> <td>" + testSQL + "</td> </tr>");
 	          if (rs == null) {
 	              errOut.println("<tr> <td>Result</td> <td>"
 	              + result + "</td> </tr>");
@@ -725,7 +724,6 @@
 	                  errOut.println("</td> </tr>");
 	              }
 	          }
-	          errOut.println("</table><br />");
 	      }
 	      if (rs != null) {
 	        ResultSetMetaData meta = rs.getMetaData();
@@ -746,14 +744,16 @@
 	              for (int i = 0; i < colCount; i++) {
 	                  Object o = rs.getObject(i + 1);
 	                  String colVal = (o != null) ? o.toString() : "";
-	                  colVal = URLEncoder.encode(colVal, "UTF-8");
+//	                  colVal = URLEncoder.encode(colVal, "UTF-8");
                       out.write(colVal);
 	                  if (i + 1 < colCount) out.write("|");
 	              }
 	              out.write("\n");
 	          }
 	        }
+	        errOut.write("<tr> <th>Result</th><td>Exported Users: " + retVal + "</td></tr>");
 	      }
+	      errOut.println("</table><br />");
 	    }
 	    catch (Exception e) {
 	      e.printStackTrace();