New dumpqueryresults component for handy debugging etc.

diff --git a/yarrg/web/dumpqueryresults b/yarrg/web/dumpqueryresults
new file mode 100644 (file)
index 0000000..c653d81
--- /dev/null
+++ b/yarrg/web/dumpqueryresults
@@ -0,0 +1,20 @@
+<%args>
+$sth
+</%args>
+<table frame=box rules=all>
+<tr>
+% foreach my $field (@{ $sth->{NAME} }) {
+<th><% $field |h %>
+% }
+</tr>
+% my @row;
+% while (@row=$sth->fetchrow_array) {
+<tr>
+% foreach my $cell (@row) {
+<td>
+<% $cell |h %>
+</td>
+% }
+</tr>
+% }
+</table>

diff --git a/yarrg/web/profitable_trades b/yarrg/web/profitable_trades
index 6aab676d4fee0e27b38f79c78738edf5b883ecfc..1566baf1dd25c6dcc9fee8a4f0ef822fab664d3f 100755 (executable)
--- a/yarrg/web/profitable_trades
+++ b/yarrg/web/profitable_trades
@@ -23,19 +23,7 @@ my $sth=$dbh->prepare(
 
 $sth->execute();
 </%perl>
-<table frame=box rules=all>
-<tr><td>commod</td><td>buy island</td><td>buy stall</td><td>buy price</td><td>buy quantity</td><td>sell island</td><td>sell stall</td><td>sell price</td><td>sell qty</td></tr>
-% my @row;
-% while (@row=$sth->fetchrow_array) {
-<tr>
-% foreach my $cell (@row) {
-<td>
-<% $cell %>
-</td>
-% }
-</tr>
-% }
-</table>
+<& dumpqueryresults, sth => $sth &>
 
 </BODY>
 </HTML>