[web2py] DAL : Compute Fields and validate_and_insert ?

2013-02-25 Thread Sebastien Stormacq
Hello, I am using compute fields on a table. The data are inserted with validate_and_insert method from args received in the URL. None of my compute fields are added to the DB. Question : is the validate_and_insert method supposed to trigger compute fields ? Thanks Seb -- --- You

[web2py] Problem with combination of SQLForm.grid + LEFT JOIN + Computed Fields

2013-01-15 Thread Sebastien Stormacq
Dear All, In one of my views, I am using a SQLForm.grid object. The grid is fed with a table that has two computed fields and the query needs a LEFT JOIN to another table. The grid also use 'Links' to compute a field (create an column with an IMG element depending on a column's value)

[web2py] Re: Problem with combination of SQLForm.grid + LEFT JOIN + Computed Fields

2013-01-15 Thread Sebastien Stormacq
OK, using a debugger, I found out my problem. When doing a left join, the row variable does not contain directly the fields. We must use row.table_name.field_name instead. This is now working. Problem solved. Seb On Tuesday, January 15, 2013 4:13:45 PM UTC+1, Sebastien Stormacq wrote

[web2py] Code submission : Select All checkbox in SQLForm.grid

2012-03-28 Thread Sebastien Stormacq
Dear All, I recently used a SQLFORM.grid in my app and I wanted #1 the possibility to have checkboxes to select multiple row to delete #2 customize the text of the submit button #3 have a select all checkbox in the table header. #1 was easy to solve with the help of this mailing list. (see

Re: [web2py] Re: SQLForm.grid : is it possible to delete multiple rows at once ?

2012-03-26 Thread Sebastien Stormacq
Thanks ! On Saturday, March 24, 2012 5:26:52 AM UTC+1, Javier wrote: sabsto You can use selectable, for example: selectable = lambda ids: delete(ids) form=SQLFORM.grid(query,​selectable=selectable) def delete(ids): to_delete=db(db.tabla.id.​belongs(ids)) to_delete.delete()

[web2py] Re: auth.login() from inside a component in a dialog

2012-03-23 Thread Sebastien Stormacq
Hello Anthony, Could you share your code for modal login ? I am beginning with web2py and would love to learn from that example. Thanks Seb On Friday, March 23, 2012 4:08:51 AM UTC+1, Anthony wrote: @anthony: actually, on closer inspection, the doc does go into some details:

[web2py] Re: auth.login() from inside a component in a dialog

2012-03-23 Thread Sebastien Stormacq
Thanks ! On Friday, March 23, 2012 12:57:10 PM UTC+1, weheh wrote: Sorry, last message got mangled somehow. Here goes again. Sebastian, here's what I'm using: