title: How to see result from mysql query in netbeans
body: <p>When I run the netbeans debugger on my project I can't see the resulting tables from my SQL queries. How can I see those results in the same way as I see other variables?</p>
  
  <p>Here is an example query: </p>
  
  <pre><code>&lt;sql:query var="query" dataSource="myDB"&gt;
  SELECT * FROM data
  &lt;/sql:query&gt;
  &lt;c:set var="queryInfo" value="${query.rows[0]}"/&gt;
  </code></pre>
  
  <p>How can I see the queryInfo/query table using the debygger? When I try to show the result as a html table I don't get any error messages and I only get an empty table. As such I suspect the query return an empty table.</p>
  
  <p>EDIT: To further clarify, my full query is:</p>
  
  <pre><code>SELECT * FROM weather_station
  WHERE weather_station.belong_to = ? &lt;sql:param value="${param.id}"/&gt;
  ORDER BY when_inspected DESC
  </code></pre>
  
  <p>There might be a problem with line 2 in the query, but I am not able to find the walue of param.id. It works in a different query on the same page.</p>
  
  <p>EDIT2: Even though this particular problem is solved, I am still wondering how I easy can see the result from a query in netbeans. When I use JSP it does not show as a variable in the output window.</p>