Re: [SQLObject] MAX value

[Oleg B. <ph...@ph...>]

On Tue, Feb 13, 2007 at 04:23:27PM -0600, Jim Steil wrote:
> Is there an easy way to return a row with a maximum column value in it?

> class Process(SQLObject):
>     class sqlmeta:
>         style = Style(longID=True)
>         idName = 'processId'
> 
>     name = UnicodeCol(length=50)
>     processKey = UnicodeCol(length=4)
>     description = UnicodeCol()
>     startAt = TimeCol()
>     intervalMinutes = IntCol()
>     gracePeriodMinutes = IntCol()
>     createdOn = DateCol(default=datetime.now())

print Process.select(Process.q.startAt > time(12, 0)).max(Process.q.intervalMinutes)

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.