db (db .table.id>0).select(orderby=~db.table.recordtiime,limitby=(0,1)).first()
On Mar 6, 2010, at 9:59 AM, Yannick wrote:
Hello mate, I was wondering if any one of you knows how to retrieve the latest UPDATE record in Web2py ??? Like for example how to do this using DAL of Web2py: - Select top 1 <Col-name> from <table> order by RecordTime desc OR this one: - Select <Col-name> from <table> order by RecordTime asc LIMIT 1 Anyway please let me know how I can select the latest update record on a table that contain "RecordDateTime" as one of his column. I'm using DB Postgres. Thanks very much, Yannick P.
-- 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.
