I have the paid-for docs, full google, and several days later I still do not know how to use the JbossQL to get a SUM. Could someone enlighten me please? It should have been simple...
-D --__--__-- Subject: RE: [JBoss-user] RE: jboss4 and EJB2.1 ejb-ql? Date: Mon, 12 Jan 2004 16:25:24 -0600 From: "Alexey Loubyansky" <[EMAIL PROTECTED]> You answered the question yourself. ejb.select - method level, jboss.query - class level. > -----Original Message----- > /** > * @ejb.select > * signature=3D"java.util.Float=20 > ejbSelectStoreSum(java.lang.String store, java.util.Date theday)" > * query =3D "SELECT o.amountpaid FROM Store AS o WHERE=20 > ((o.store =3D ?1) AND (o.transday=3D?2))" > * @jboss.query > * signature=3D"java.util.Float=20 > ejbSelectStoreSum(java.lang.String store , java.util.Date theday)" > * strategy=3D"none" > * query =3D "SELECT SUM(o.amountpaid) FROM Store AS o WHERE=20 > ((o.store =3D ?1) AND (o.transday=3D?2))" > **/ ------------------------------------------------------- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
