--- android/TrainInfoService/src/dk/thoerup/traininfoservice/DumpResultSet.java 2009/11/01 17:15:13 494 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/DumpResultSet.java 2010/05/07 17:30:07 715 @@ -96,7 +96,7 @@ res = dumpResultset("SELECT name,count(*) FROM trainstations GROUP BY name HAVING count(*) > 1"); } else if (dump.equals("allfull")) { res = dumpResultset("select *, " + - "'Maps' AS maps, " + + "'Maps' AS maps, " + "'Bane.dk Fjern' as banedk1, " + "'Bane.dk stog' as banedk2 " + "FROM trainstations ORDER BY id"); @@ -104,10 +104,12 @@ res = dumpResultset("SELECT * FROM trainstations WHERE enabled = false ORDER BY id"); } else if (dump.equals("noaddress")) { res = dumpResultset("SELECT * FROM trainstations WHERE address IS NULL or address = '' "); + } else if (dump.equals("aliases")) { + res = dumpResultset("SELECT * FROM trainstations WHERE aliases IS NOT null"); } } if (res == null) { - res = "All
All with links
Missing coords
Duplicate stations
Disabled stations
No address"; + res = "All
All with links
Missing coords
Duplicate stations
Disabled stations
No address
Has aliases"; } resp.setContentType("text/html");