<select name="weatherStat" id="States">
<%
try {
Connection connection = DataBaseConnectionManager.getConnection();
String sqlQuery = "SELECT distinct state FROM ols_weather_current ORDER BY 1 asc";
ResultSet rst2;
PreparedStatement pstmt;
pstmt = connection.prepareStatement(sqlQuery);
rst2 = pstmt.executeQuery(sqlQuery);
while (rst2.next ()) {
<option value=rst2.getString("state")></option>
}
rst2.close();
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
%>
</select>
having trouble...any suggestions?