[web2py] Re: Dal Field Types

Thanks Guys Le jeudi 3 mars 2016 02:23:54 UTC-5, Daniel Lafrance a écrit : > > Hi group > > I am trying to build a db dynamic app but I am stick on the following > problem. > > I am able to get the filenames of a table by the syntax ; > > fields = list(db.resultats.ke

[web2py] Dal Field Types

Hi group I am trying to build a db dynamic app but I am stick on the following problem. I am able to get the filenames of a table by the syntax ; fields = list(db.resultats.keys()) But I am unable to find how to get the field types. Is there a special syntax that i could use ? Something lik

[web2py] Dal select column sort order

Hi I am using a query like ; rows = db(db.v_histo_freins.busid == busid).select() and I am using a function to generate the HTML table. I made this function to serve my look and feel needs and so it would adapt to any kind of rows result. When I run the query and my the function, I get th

[web2py] Re: Unclear how to create a unique multiple fields on web2py

e b field to report the > error. You can do this in the action, before SQLFORM... > > def index(): > if request.post_vars.b_field: > db.sometable.b_field.requires = > IS_NOT_IN_DB(db(db.sometable.a_field== > request.post_vars.a_field),'b_field') > for

[web2py] Unclear how to create a unique multiple fields on web2py

Hi gang I am quite new to web2py and i am confronted to the following lack of my own knowledge. In other DB engine one can write : create table sometable ( a_field varchar(10), b_field timestamp default date(now()), unique(a_field, b_field) ); wich I have reproduce in web2py using