DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=7181>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=7181 esql:group behaves erratically [EMAIL PROTECTED] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED ------- Additional Comments From [EMAIL PROTECTED] 2002-03-17 23:41 ------- <esql:execute-query> <esql:query> SELECT department.name, employee.id, employee.name as empName FROM department, employee WHERE department.id = employee.department_id ORDER BY department.name </esql:query> <esql:results> <esql:row-results> <esql:group group-on='name'> <Department><xsp:attribute name='name'><esql:get-string column='name'/></xsp:attribute> <esql:member><employee><esql:get-string column='empName'/></employee></esql:member> </Department> </esql:group> </esql:row-results> </esql:results> </esql:execute-query> Works for me. I'm on linux/jdk1.3/tomcat 4.0.1 but i don't see that this would make any difference. What doesn't work is: <esql:group group-on="1"> In this case, the logicsheet incorrectly tries to use resultSet.get(String) instead of resultSet.get(Int). I will post a patch to correct that behavior shortly. If i don't understand the bug correctly or if the code above still doesn't work for you, please post some more info. Other problems that you are running into seem to be with hsql <esql:group group-on="department.name"> or <esql:get-string column="department.name"/> as i can do this successfully with mysql. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
