the only sure thing about this whole thing is "once fixed, add a test for it". Leonel is right: we have two very different syntaxes for the same exact outcome and it makes difficult to track all variables when implementing (or fixing) a feature.
On Friday, October 31, 2014 10:30:13 PM UTC+1, Anthony wrote: > > On Friday, October 31, 2014 5:10:24 PM UTC-4, Leonel Câmara wrote: >> >> It feels completely unnatural to me to just ask the DAL for fields. >> > > Then how in web2py would you best represent the following? > > SELECT name FROM person > > It seems to me that db().select(db.person.name) is the closest you can > get. db(db.person).select(db.person.name) is a shortcut for db( > db.person.id != None).select(db.person.name), which translates to "SELECT > name FROM person WHERE (person.id IS NOT NULL)", which is not quite the > same as the above SQL statement. > > Anthony > -- 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.