DO NOT REPLY [Bug 7181] - esql:group behaves erratically

[bu...@apache.org]

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

phantom@stserv.hcf.jhu.edu changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED



------- Additional Comments From phantom@stserv.hcf.jhu.edu  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: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org