chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.web-test.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
fix spurious comma causing syntax error in query
[ypp-sc-tools.web-test.git]
/
yarrg
/
web
/
query_commod
diff --git
a/yarrg/web/query_commod
b/yarrg/web/query_commod
index 0bd36cbffa4db9e958ce30cbc84521a181e70862..ee4c9f3177aad6eb311bcb11ecb7e2b5234ca173 100644
(file)
--- a/
yarrg/web/query_commod
+++ b/
yarrg/web/query_commod
@@
-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"
);