Re: Sort resultset from multiple requests

2008-09-24 Thread Heliodromel
Hi Kay, Thanks for your answer. Actually, the getCatName is just a example, it could be "select * from Cat" and the table Cat would be constituted with 2 fields : a name and an age. I had already tried to use the groupBy property but it didn't work. Actually i was using it wrong. This morning,

Sort resultset from multiple requests

2008-09-23 Thread Heliodromel
Hi everybody, i've got a question about sorting. It's maybe stupid but i can't find the solution. Here is my problem : I make a simple request in a database, for example : select firstname, lastname, age, ref_cat from MyTable And i got a simple resultmap, something like that :