Can't you sort by day and get the first? I don't know if max exists. Regards, Tiago
On Mon, Feb 15, 2010 at 10:49 PM, baloan <[email protected]> wrote: > Now I'm trying to do > > SELECT MAX(DAY) FROM T WHERE DAY < '2007-12-04' > > and I fail to find an operator for "MAX" in the web2py book. Is it > supported? > > Regards, Andreas > > > PS: The online book is splendid. I like it. Much easier to work with. > Now web2py is a truly "free" application. > > Note: In section 6.5 the paragraph on "Logical Operators" has some > typos at the operators (&~). > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<web2py%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
