Re: [web2py] Re: SQLform grid custom function for delete

2015-11-01 Thread Anthony
I see the problem. When the grid involves a join, you must refer to fields within a row via the row.table.field format. However, when you view/edit a record from such a grid, only the record from a single table is shown (i.e., there is no longer a join involved), so you must now refer to fields

Re: [web2py] Re: SQLform grid custom function for delete

2015-11-01 Thread Vid Ogris
Thank you so much. This works like a charm. 2015-11-01 14:24 GMT+08:00 Anthony : > I see the problem. When the grid involves a join, you must refer to fields > within a row via the row.table.field format. However, when you view/edit a > record from such a grid, only the

[web2py] SQLFORM grid special edit form for specific record

2015-11-01 Thread Yebach
Hello SO I have a SQLFORM.grid. I would like to create an edit view for specific records in db (based on one field name) that instead of text field shows checkbox and writes True/false into database I hope question is understandable any suggestions? thank you -- Resources: -

[web2py] are there security problems with altering db.auth_group to allow "role" field duplicates?

2015-11-01 Thread Alex Glaros
would there be any security problems if I alter db.auth_group to allow role field duplicates? There is a multi-tenant situation where I want users to have access to a standard-core, common number of shared roles, but also have ability to create their own roles. (1) If I use "_common_filter",

[web2py] Re: are there security problems with altering db.auth_group to allow "role" field duplicates?

2015-11-01 Thread Anthony
I'm not sure of all the implications, but if you're going to take this approach, you would have to use the "group_id" rather than the "role" when calling .has_membership() and .add_membership() (if you use the "role", it will simply identify the first group whose role matches, which may be the

[web2py] Re: SQLFROM GRID ADD EVENT WHEN UPDATE

2015-11-01 Thread Anthony
http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=onupdate On Sunday, November 1, 2015 at 5:12:40 PM UTC-5, Alessio Varalta wrote: > > Resolve with onupdate attribute sqlgrid I don't see in the guide this part > first:) > > On Sunday, 1 November 2015 22:13:57 UTC+1,

[web2py] SQLFROM GRID ADD EVENT WHEN UPDATE

2015-11-01 Thread Alessio Varalta
Hi, I have a SQLFORM grid and i have to send a email when a filed is set to true..Is possibile to make this operations? -- 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] Re: SQLFROM GRID ADD EVENT WHEN UPDATE

2015-11-01 Thread Alessio Varalta
Resolve with onupdate attribute sqlgrid I don't see in the guide this part first:) On Sunday, 1 November 2015 22:13:57 UTC+1, Alessio Varalta wrote: > > Hi, I have a SQLFORM grid and i have to send a email when a filed is set > to true..Is possibile to make this operations? > -- Resources: -