RE: How to Obtain a Max Column Value Using Torque

[Gareth Boden]

criteria.addSelectColumn("MAX(" + Peer.COLUMN + ")");
List l = Peer.doSelectVillageRecords(criteria);
if (l != null) {
  return ((Record) l.get(0)).getValue(1).asInt();
}

        -----Original Message----- 
        From: Juan Perez 
        Sent: Tue 29/10/2002 22:10 
        To: 'Turbine Torque Users List' 
        Cc: 
        Subject: How to Obtain a Max Column Value Using Torque
        
        

        Hello,
        I am trying to do this query: SELECT MAX(COLUMN_NAME) FROM
TABLE_NAME
        using a Criteria object but I cannot find any way of doing this.
        
        I would appreciate it if someone would please point me in the
        right direction. Thank you for your prompt response! :)
        
        Sincerely,
        Juan
        
        --
        To unsubscribe, e-mail:   <
mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org>
        For additional commands, e-mail: <
mailto:turbine-torque-user-help@;jakarta.apache.org>
        
        

<<winmail.dat>>

--
To unsubscribe, e-mail:   <mailto:turbine-torque-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-user-help@;jakarta.apache.org>