[web2py] Subquery question

2016-12-11 Thread Anthony
Computed fields are stored in the database. It is virtual fields that are not stored in the database. 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)

[web2py] Subquery question

2016-12-11 Thread Donald McClymont
Computed fields are not stored in the database so I don't think you can do the sort of query you are trying to do. The computed field is only useful once you have a row set to work with. My understanding of this is that you need to run the queries against the latitude and longitude fields you

[web2py] Subquery question

2016-12-11 Thread Gael Princivalle
Hello everybody. I don't find the solution for selecting what I need, selecting comments for events in a specific area. DB: #Events table with a geometry fields. I use a PostGis DB. db.define_table('events', Field('title', type='string', requires=IS_NOT_EMPTY(), label=T('Title' )), Fiel