[web2py] Re: Unexpected common filter behavior

2014-11-01 Thread Leonel Câmara
Then how in web2py would you best represent the following? SELECT name FROM person db(db.person).select(db.person.name) Seems reasonable to me. It just seems weird to me to infer the tables from the fields as I see picking the table as a query on the database for a table with a given

[web2py] Re: Unexpected common filter behavior

2014-11-01 Thread Niphlod
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,

[web2py] Re: import error when running compiled version of web2py

2014-11-01 Thread Niphlod
web2py.exe doesn't import libraries installed on the system. the whole idea of a binary is to make it run on system that have NO python whatsoever. If your app needs the requests library, you should either ship it in /application/modules or in /site-packages (one of the folders of the web2py

[web2py] Re: Unexpected common filter behavior

2014-11-01 Thread Anthony
On Saturday, November 1, 2014 9:20:18 AM UTC-4, Niphlod wrote: 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

[web2py] Re: Unexpected common filter behavior

2014-11-01 Thread mcamel
Just as a workaround for this common filter issue and for possible hidden similar problems, it could be created a WHERE clause like '1=1' when user does not specify any query at all. It's dirty, but it seems to me it has no side effects. Can we state 'WHERE 1=1' is identical to no WHERE at

[web2py] Re: Unexpected common filter behavior

2014-11-01 Thread Anthony
On Saturday, November 1, 2014 8:26:44 AM UTC-4, Leonel Câmara wrote: Then how in web2py would you best represent the following? SELECT name FROM person db(db.person).select(db.person.name) Seems reasonable to me. It's not entirely unreasonable, but neither is it the most straightforward

[web2py] Re: type 'exceptions.AttributeError' function 'GEOSversion' not found

2014-11-01 Thread Leonel Câmara
Did you install postgis? Did you CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; On the database you're using? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Remember me not backwards compatible

2014-11-01 Thread Robin Manoli
Hey, I just noticed that in a custom form, the remember me option stopped working since I updated web2py. Apparently the name value has changed from remember to remember_me. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Remember me not backwards compatible

2014-11-01 Thread Anthony
On Saturday, November 1, 2014 3:06:06 PM UTC-4, Robin Manoli wrote: Hey, I just noticed that in a custom form, the remember me option stopped working since I updated web2py. Apparently the name value has changed from remember to remember_me. Technically I suppose the name of that field

[web2py] Javascript layout

2014-11-01 Thread Richard D
Hi, I want to use a javascript layout library (jqxwidgets). With bootstrap layout rendering and updates using ajax components is clear to me a applied with success. But the javascript layout feels different and some experiments result only in components with the status loading. Can anybody

[web2py] Re: GAE NDB is there a problem with using belongs on an id field?

2014-11-01 Thread Russ King
I have established at least a work-around to this issue by updating google.py file in adapters and creating a new class to use instead of GAEF when ndb is being used: class GAEFNDB(object): #This is a work around to belongs not working on id fields when using ndb def

[web2py] Changing column order in an SQLFORM.grid that takes a links parameter

2014-11-01 Thread Spokes
My page has an SQLFORM.grid which has a column that's created with the use of the links parameter. By default, this column is generated as the rightmost column of the grid. If there a way to make this column the leftmost column instead? Thanks. -- Resources: - http://web2py.com -

[web2py] Re: update_or_insert

2014-11-01 Thread Luis Ramos
Anthony, thanks for your response, the only inconvenience that I see is that the 'update_date' Field will be updated if there's a change in the whole Row, instead of a particular Cell. How can we specify to update if a particular Cell changed? On Friday, October 31, 2014 10:24:15 PM UTC-4,

[web2py] passing / appending URL instead of string

2014-11-01 Thread neub
What I've written will display the name of an assay if criteria are met- using a list. Rather, I'd like to display a link to a URL, not just the name of the assay. what I have: def assay_display(row): assay_list = list() if db(row.MML.lot == db.amino_acid.lot).select():

[web2py] display link to url, not just name of page

2014-11-01 Thread neub
I'd like to display a link to an existing page when criteria are met. Code I've written only lists the name of the page - it uses a list - then returns the contents of the list. What I have: def assay_display(row): assay_list = list() if db(row.MML.lot == db.amino_acid.lot).select():

[web2py] duplicate column name error

2014-11-01 Thread Ramashish Gaurav
Hi all, I am following the second video tutorial for learning web2py by Mr. Massimo, where he teaches to make clone of reddit. But I am stuck at this error. Please help me debug it. Following is the error and my database model: Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Traceback