[web2py] Re: JQuery floatThead floating table header

2019-12-09 Thread Mark
Never mind, I just found the solution. The code need to be changed to "var $table = $('table');" On Monday, December 9, 2019 at 1:42:34 PM UTC-5, Mark wrote: > > Hello, > > I try to use the following JQuery code in Web2py 2.18.3 or 2.4.5, but it > didn't work. I hope that the table header is

[web2py] JQuery floatThead floating table header

2019-12-09 Thread Mark
Hello, I try to use the following JQuery code in Web2py 2.18.3 or 2.4.5, but it didn't work. I hope that the table header is fixed/floating, and I am not sure if there is a better way to do it in web2py. The link to jquery.floatThead is https://mkoryak.github.io/floatThead/. Any help would be

[web2py] Re: Something strange in my query

2019-12-09 Thread Val K
As you can see, this is a Set, not just an attribute. When you select from a table that has FK, Pydal forms Sets for related tables, Set is the type that db (...) returns -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Re: Something strange in my query

2019-12-09 Thread Константин Комков
I understood, that I select only one table and need take row.NAME without tablename. But it's intresting what is a_students attribute? понедельник, 9 декабря 2019 г., 13:30:00 UTC+3 пользователь Константин Комков написал: > > My query return attribute 'a_students' for row, but in select I wrote

[web2py] Something strange in my query

2019-12-09 Thread Константин Комков
My query return attribute 'a_students' for row, but in select I wrote 'db.a_groups.NAME'. Why? tables.py db.define_table( 'a_groups', Field('ACADEMIC_YEAR', 'integer'), Field('NAME', length=25), Field('STATUS', 'integer'), Field('INACTIVE', 'integer', rname='"INACTIVE"'), Field('FO',

[web2py] Smartgrid with multiple references between tables - Undocumented - Solved

2019-12-09 Thread Paul Ellis
When using Smartgrid and there are multiple links between two tables. For example a user_id might appear multiple times in db.offer because of created_by, updated_by, belongs_to fields. db.define_table( 'offer', Field('offer_number', unique=True, label = T('Offer Number')),