<%@ page import="dal.*,java.util.*,java.text.*" %>

	<% ArrayList partenaires = DBHelper.executeQuery("select * from partenaire order by commune, nom", null); String curcommune = ""; int curpartenaire = 0; for(int i=0; i <% if(!commune.equals(curcommune)) { curcommune = commune; %> <% } %> <% if(newpartenaire) { curpartenaire = id_partenaire; %> <% } %> <% } %>   <%= commune %> <% } %> <% ArrayList params = new ArrayList(); params.add(new Integer(id_partenaire)); 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_partenaire tp where id_partenaire = ?) as t2 on t1.id_theme = t2.id_theme", params); for(int it=0; it <% } else { int id_theme = Integer.parseInt(theme_row.get("id_theme").toString()); String nom_theme = theme_row.get("nom").toString(); %> <% } %> <% } %> <% if(newpartenaire) { %>