142 |
res = dumpResultset("SELECT * FROM trainstations WHERE address IS NULL or address = '' "); |
res = dumpResultset("SELECT * FROM trainstations WHERE address IS NULL or address = '' "); |
143 |
} else if (dump.equals("aliases")) { |
} else if (dump.equals("aliases")) { |
144 |
res = dumpResultset("SELECT * FROM trainstations WHERE aliases IS NOT null"); |
res = dumpResultset("SELECT * FROM trainstations WHERE aliases IS NOT null"); |
145 |
|
} else if (dump.equals("tritinfo")) { |
146 |
|
res = dumpResultset("SELECT * FROM trainstations WHERE tritinfo IS NOT null"); |
147 |
} else if (dump.equals("updatecoords")) { |
} else if (dump.equals("updatecoords")) { |
148 |
res = dumpUpdate("UPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)"); |
res = dumpUpdate("UPDATE trainstations SET earth_coord = ll_to_earth(latitude,longitude)"); |
149 |
} |
} |
156 |
"<a href=DumpResultSet?dump=disabled>Disabled stations</a><br>" + |
"<a href=DumpResultSet?dump=disabled>Disabled stations</a><br>" + |
157 |
"<a href=DumpResultSet?dump=noaddress>No address</a><br>" + |
"<a href=DumpResultSet?dump=noaddress>No address</a><br>" + |
158 |
"<a href=DumpResultSet?dump=aliases>Has aliases</a><br>" + |
"<a href=DumpResultSet?dump=aliases>Has aliases</a><br>" + |
159 |
|
"<a href=DumpResultSet?dump=tritinfo>Has tritinfo</a><br>" + |
160 |
"<a href=DumpResultSet?dump=updatecoords>update coords</a><br>"; |
"<a href=DumpResultSet?dump=updatecoords>update coords</a><br>"; |
161 |
} |
} |
162 |
|
|