Hi,
What errors do you get?
Without further details, it won't be easy to help you :-(
--
Guillaume Laforge
http://glaforge.free.fr/weblog
Furash Gary wrote:
import groovy.sql.*;
import groovy.xml.*;
release = "3.11";
I'm trying to spit out a td row for each line of my sql, but it
complains about closures.
sql = Sql.newInstance("jdbc:mysql://mcaosdev2:3306/mantis_db",
"furashgf", "melissa", "org.gjt.mm.mysql.Driver");
getWorkloadSql = <<<EOS
SELECT mut.last_name, mut.first_name, COUNT(*) AS total_tasks,
SUM(IF(mbt.projection IS NULL OR mbt.projection = 10, 1,0)) AS
unsized_tasks,
SUM(mbp.value) AS workload
FROM mantis_user_table AS mut
LEFT OUTER JOIN mantis_bug_table AS mbt ON (mbt.handler_id = mut.id)
LEFT OUTER JOIN mantis_project_version_table AS mpvt ON (mpvt.id =
mbt.version_id)
LEFT OUTER JOIN m_bug_status AS mbs ON (mbs.status_cd = mbt.status)
LEFT OUTER JOIN m_bug_projection AS mbp ON (mbp.projection_cd =
mbt.projection)
WHERE mpvt.version = ${release} AND mbs.is_active_state = "Y" AND
mut.role_cd IN ("DEV", "ADM")
GROUP BY mut.last_name, mut.first_name
ORDER BY mut.last_name, mut.first_name;
EOS
htmlOut = new MarkupBuilder();
htmlOut.html() {
head() {
title("Load By Developer for Release $release");
}
body() {
table() {
tr() {
th("Team Member");
th("Total Tasks");
th("Workload");
}
sql.eachRow(getWorkloadSql) {
tr() {
td(it.last_name + ", " + it.first_name);
td(it.total_tasks);
td(it.workload);
}
}
}
}
}
println(htmlOut);
| 