<%
ArrayList lieus = DBHelper.executeQuery("select * from lieu order by commune, nom", null);
String curcommune = "";
int curlieu = 0;
for(int i=0; i
<% if(!commune.equals(curcommune)) {
curcommune = commune; %>
<%= commune %>
<% } %>
<% if(newlieu) {
curlieu = id_lieu; %>
<% } %>
<%
ArrayList params = new ArrayList();
params.add(new Integer(id_lieu));
ArrayList themes = DBHelper.executeQuery("select t1.id_theme, t2.id_theme as id_theme2, nom from theme t1 left outer join (select id_theme from theme_lieu tp where id_lieu = ?) as t2 on t1.id_theme = t2.id_theme", params);
for(int it=0; it
