JSTL help !
Hello,
Sorry for my english.
we have changing our mysq version version from 4 to 5. I encounter problems of bearing of a struts application which functioned without problem under mysql 4.
I have a query like this :
<sql:query dataSource="jdbc/mysql/MData" var="myQuery">
SELECT a.id AS id, a.numero AS num, a.name AS nam, a.departement AS dep,
b.returnType AS rt,
c.id AS cid, c.rdate AS rd,
IF ( SUM( IF(d.result = 'satistified', 1, 0) ) = 0 ,'-','yes' ) AS rc,
IF ( SUM( IF(d.injoignable='yes', 1, 0 ) ) = 0, '-','yes' ) AS inj,
FROM (atable a, btable b)
LEFT JOIN ctable c ON a.id = c.id_atable
LEFT JOIN dtable d ON a.id = d.id_atable
WHERE a.id = b.id_atable
GROUP BY num
ORDER BY rc DESC, inj DESC
</sql:query>
the requete execute correctly but nothing is posted with the screen using :
<c:forEach var="row" items="${myQuery.rows}">
<c:out value="${row.id}"/>
<c:out value="${row.num}"/>
....
Please HELP :-(
