Member Avatar for eddy556

Please take a lot at this. Tomcat is reporting the variable editQuestion cannot be resolved.

<%
String key = request.getParameter("edit");
  ResultSet columns1 = statement.executeQuery("SELECT * FROM Questions WHERE ID ="+ key +"");
  
  while(columns1.next())
  {
    String editid = columns1.getString("ID");
    String editQuestion = columns1.getString("Question");
    String editAnswer = columns1.getString("Answer");
	String editUpdated = columns1.getString("Timestamp");
	String editAuthor = columns1.getString("Author");	
}
%>
<form action="viewFAQ.jsp" method="get">
<INPUT readonly TYPE="TEXT" NAME="ID" value="<%= key %>">
<TEXTAREA NAME="comments" COLS="40"ROWS="6"><%= editQuestion %></TEXTAREA>
</form>

Thanks :)

  • 1 Contributor
  • 1 Reply
  • 76 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by eddy556
Member Avatar for eddy556

Hey, I've managed to solve this....turns out I had to declare the variables i.e. String question = null; outside the loop.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.