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 <balo...@googlemail.com> 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 web...@googlegroups.com. > To unsubscribe from this group, send email to > web2py+unsubscr...@googlegroups.com<web2py%2bunsubscr...@googlegroups.com> > . > 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 web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
