chiark / gitweb /
fix spurious comma causing syntax error in query
authorIan Jackson <ijackson@chiark.greenend.org.uk>
Sun, 23 Aug 2009 21:23:20 +0000 (22:23 +0100)
committerIan Jackson <ijackson@chiark.greenend.org.uk>
Sun, 23 Aug 2009 21:23:20 +0000 (22:23 +0100)
yarrg/web/query_commod

index 0bd36cbffa4db9e958ce30cbc84521a181e70862..ee4c9f3177aad6eb311bcb11ecb7e2b5234ca173 100644 (file)
@@ -103,7 +103,7 @@ foreach my $bs (split /_/, $ARGS{BuySell}) {
                        sum(qty) as tqty
                FROM islands $joinkind $bs offers
                ON islands.islandid == offers.islandid AND commodid == ?
-               GROUP BY islands.islandid,
+               GROUP BY islands.islandid
                ORDER BY archipelago, islandname"
                );