Hi Nilesh, I'm not sure i understood your question, but i'll try to help.
As far as i got your question, i guess that is not possible right away from iBATIS. But you can make all sort of things in your DAO layer. Have you wondered that? Cheers, Daniel Silva. On 6/14/05, Nilesh Bhattad <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I need to generate some reports using iBatis, JSP/XSLT. For example, one > report should list out all the companies and each company will have the list > of employees associated with that company. > > > > CompanyNo. CompanyName > > 1 > ABC Pvt Ltd > > EmpNo EmpName > > 1 Emp1 > > 2 Emp2 > > > > 2 > XYZ Pvt Ltd > > EmpNo EmpName > > 3 Emp3 > > 4 Emp4 > > > > > > Is there a way to write sql statements in iBatis which will produce the > output as List of HashMaps where each hashmap will carry a child list > alongwith current record data..? Once I get the output in this fashion, I > can write JSP/XSLT code accordingly which can print the report in above > format.. > > > > Would someone please suggest a way of generating this kind of report? I > apologize if a similar question was already asked in this forum… > > > > ~ Nilesh
