/[projects]/android/TrainInfoService/src/dk/thoerup/traininfoservice/db/StationDAO.java
ViewVC logotype

Diff of /android/TrainInfoService/src/dk/thoerup/traininfoservice/db/StationDAO.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1509 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";
Legend:
Removed from v.1509  
changed lines
  Added in v.1510
  ViewVC Help
Powered by ViewVC 1.1.20