{#example_1}
<table>

 <tr>
  <th>ID</th>
  <th>Name</td>
  <th>Flatulence Score</th>
 </tr>

{% loop in $biggest_tooters as $tooter %}
 <tr>
  <td>{$tooter.id}</td>
  <td>{$tooter.name}</td>
  <td align="center">{$tooter.flatulence}</td>
 </tr>
{% endloop %}

</table>
{#}

import com.x5.template.Theme;
import com.x5.template.Chunk;
import com.x5.db.Query;
import com.x5.util.TableData;

//...

Theme theme = new Theme("examples");
Chunk html = theme.makeChunk("loopquery#example_1");

String SQL = "SELECT id,name,flatulence FROM tooters "
	+ "WHERE flatulence > 5 "
	+ "ORDER BY flatulence DESC LIMIT 5";

Query result = db.doSelect(SQL);

//
// Since Query implements the com.x5.util.TableData interface,
// the results may be placed directly into the Chunk.
//
// The explicit cast is not necessary, just here for clarity.
//
html.set("biggest_tooters", (TableData)result);

html.render( out );