On Tuesday, February 17, 2015 at 3:56:59 PM UTC-8, Francisco Costa wrote: > > if you query db like > > events = db(db.events).select(orderby=~db.events.end_date) > > All the events without end_date will show in last place in rows. > > How can you make them show in first, but still having end_date descending? >
How big is events (how many rows are you getting back)? If it's not too big, just use a python for loop to pick out the 2 different groups. If it's way too big for that, then split into 2 queries? /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
