[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 receive

[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 Stor

[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) Everyth

[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 ht

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.del

[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: > > >

[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: >> http://