74 |
"WHERE name ILIKE ? AND latitude IS NOT NULL AND longitude IS NOT NULL " + |
"WHERE name ILIKE ? AND latitude IS NOT NULL AND longitude IS NOT NULL " + |
75 |
"ORDER BY name "; |
"ORDER BY name "; |
76 |
stmt = conn.prepareStatement(SQL); |
stmt = conn.prepareStatement(SQL); |
77 |
stmt.setString(1, "%" + name + "%"); |
stmt.setString(1, name + "%"); |
78 |
break; |
break; |
79 |
default: |
default: |
80 |
// This should not be possible |
// This should not be possible |
126 |
} |
} |
127 |
|
|
128 |
if (request.getParameter("name") != null) { |
if (request.getParameter("name") != null) { |
129 |
name = request.getParameter("name"); |
name = request.getParameter("name").trim(); |
130 |
method = Requested.BY_NAME; |
method = Requested.BY_NAME; |
131 |
} |
} |
132 |
|
|