Parent Directory | Revision Log | Patch
revision 1507 by torben, Wed Jun 8 16:11:27 2011 UTC | revision 1510 by torben, Wed Jun 8 17:52:56 2011 UTC | |
---|---|---|
# | Line 127 public class StationDAO { | Line 127 public class StationDAO { |
127 | String SQL = "SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address, 0.0, " + | String SQL = "SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address, 0.0, " + |
128 | "levenshtein(lower(name),lower(?) ) as leven " + | "levenshtein(lower(name),lower(?) ) as leven " + |
129 | "FROM trainstations " + | "FROM trainstations " + |
130 | "WHERE (levenshtein(lower(name),lower(?) ) <= 3) AND enabled = true " + | "WHERE (levenshtein(lower(name),lower(?) ) <= 3) " + |
131 | "AND enabled = true " + | "AND enabled = true " + |
132 | "ORDER BY leven " + | "ORDER BY leven " + |
133 | "LIMIT 1"; | "LIMIT 1"; |
|
ViewVC Help | |
Powered by ViewVC 1.1.20 |