[castor-dev] RE : [castor-dev] Multi-column queries

[SYLVIE PALLUEL]

Hello Werner,   Come stai?   I was going to use SQL CALL feature to do that. But it should be interesting for me to use OQL, because I make my developing tests on a Mysql base, but the final base is Oracle …   Sylvie. ___________________ CREDI RA Sylvie Palluel [EMAIL PROTECTED] ___________________   -----Message d'origine----- De : Werner Guttmann [mailto:[EMAIL PROTECTED] Envoyé : mercredi 21 septembre 2005 09:59 À : dev@castor.codehaus.org Objet : RE: [castor-dev] Multi-column queries   Sylvie,   I am not 100% sure whether you can execute such a query using OQL, but I am defnitely sure that you could use the SQL CALL feature of OQL to execute that query, given that you adhere to the sequence of properties for fr.cnam.Cat as defined in your mapping file.   Werner   PS Have you tried to run it at all ?   From: SYLVIE PALLUEL [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 21. September 2005 08:12 To: dev@castor.codehaus.org Subject: [castor-dev] Multi-column queries Hello,   I have to make statistics on the datas of our application.   Is it possible to use OQL to make this query (I’m still in 0.9.6): select cat.color, sum(cat.weight), count(cat)   from fr.cnam.Cat cat  group by cat.color   And in this case what kind of object will be the result of the execution?    Thanks for your help.   Sylvie. ___________________ CREDI RA Sylvie Palluel   [EMAIL PROTECTED] ___________________