4 Replies Latest reply on May 7, 2004 10:10 AM by fwesterop1

    ejbSelect with MAX()

    Knut Klünker Newbie

      Hello,

      I have a lot of trouble with ejbSelect-methods.
      The ejbSelect-methode should return the MAX-Value of an Integer-field:
      <jboss-ql>
      <![CDATA[SELECT MAX(k.kundenNummer) FROM Kunde AS k]]>
      </jboss-ql>
      The deployment is OK, but then it methode returns a Double-Value. The return type is Integer and also the field in the Database.
      What ist wrong?