DaniWeb Forum Index > Web Development > JSP

illegal start of expression & type

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2007

Posts: 66

Reputation: mimsc is an unknown quantity at this point

Solved Threads: 0

mimsc

Offline

Junior Poster in Training

illegal start of expression & type

Aug 30th, 2007

 Help with Code Tags 
 java Syntax (Toggle Plain Text) 
 
<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>
<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?

•

Join Date: May 2007

Posts: 4,505

Reputation: Ezzaral has a brilliant future

Solved Threads: 521

Ezzaral

Offline

Industrious Poster

Re: illegal start of expression & type

Aug 31st, 2007

You just have your html and java code intermingled here and need to fix the tags

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
            while (rst2.next ()) {
            %>
            <option value='<%= rst2.getString("state") %>'></option>
            <%
            }
 
            rst2.close();
            while (rst2.next ()) {
            %>
            <option value='<%= rst2.getString("state") %>'></option>
            <%
            }

            rst2.close();

or use out.write() to generate the html option tags instead.

(if jwenting pops in though he will tell you not to be using java in jsp pages at all, which is consistent with the current recommendations in JSP 2.0)