Re: [web2py] list index out of range when removing some fields in SQLFORM.grid & clicking the remaining button

2020-02-15 Thread mostwanted
I saw that on the SQLFORM.grid signature, thanks, I' now left with the *"# records found"* message on the right and the bottom *"Export:"* label at the bottom without the exportclasses On Sunday, February 16, 2020 at 2:18:57 AM UTC+2, Christian Varas wrote: > > i’m quite sure that exist a

Re: [web2py] list index out of range when removing some fields in SQLFORM.grid & clicking the remaining button

2020-02-15 Thread Christian Varas
i’m quite sure that exist a switch like “searchable=False” to disable the search field. Usually I get this error when the attribute on sqlform that I’m trying to modified does not exist, maybe check the correct Index of the list. Cheers. El El sáb, 15 de feb. de 2020 a la(s) 17:13, mostwanted <

[web2py] list index out of range when removing some fields in SQLFORM.grid & clicking the remaining button

2020-02-15 Thread mostwanted
I am facing a little challenge here, I was able to remove some fields as I wanted from the SQLFORM.grid because I just wanted to use it Edit field alone & so i wanted it alone to be visible. grid = SQLFORM.grid(db.professionalsummary.posted_by==user.id, editable=True , deletable=False,

[web2py] How i remove the export label in the SQLFORM.grid after removing the exportclasses?

2020-02-15 Thread mostwanted
Hi guys, I was able to remove the export classes *exportclasses=dict(xml=False, html=False, json=False, csv=False, tsv=False, tsv_with_hidden_cols=False, csv_with_hidden_cols=False))* but now the *Export:* label is left all alone, is there a way to remove it??? Regards; -- Resources: -

Re: [web2py] Re: web2py/py4web HTML helpers as an independent module

2020-02-15 Thread António Ramos
Nice to know!! Massimo Di Pierro escreveu em sáb, 15/02/2020 às 11:29 : > pip install yatl > python > >>> from yatl.helpers import A, BUTTON, DIV > > enjoy. This has been possible for some time. > > On Friday, 14 February 2020 04:35:41 UTC-8, Ramos wrote: >> >> Hello, like pydal that is now an

[web2py] Re: MySQL server has gone away - py4web

2020-02-15 Thread Marcello
I'm with lastest version... Shouldn't reconnect to db every page load ??? If the server stays 1 hour without serving pages, a reconnection is needed... or not ? On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro wrote: > > My guess is that there is some timeout in the

[web2py] 'Unread result found' error with pyDAL and MySQL

2020-02-15 Thread Giovanni B.
Hello! I'm currently using pyDAL in a stand-alone application and I'm suffering a problem while trying to interface my code to MySQL databases. Let's take into account this simple code snippet: from pydal import DAL, Field db = DAL('mysql://user:password@127.0.0.1:3306/my_db')

[web2py] Re: MySQL server has gone away - py4web

2020-02-15 Thread Massimo Di Pierro
My guess is that there is some timeout in the mysql config example. Can you repro with latest py4web? On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: > > Hi, > > Any informatiion about this ? > Nobody using py4web with mysql ?? > > > > On Tuesday, February 11, 2020 at 6:58:11 PM

[web2py] Re: web2py/py4web HTML helpers as an independent module

2020-02-15 Thread Massimo Di Pierro
pip install yatl python >>> from yatl.helpers import A, BUTTON, DIV enjoy. This has been possible for some time. On Friday, 14 February 2020 04:35:41 UTC-8, Ramos wrote: > > Hello, like pydal that is now an independent module , would also be > interesting to have web2py HTML helpers imported as

[web2py] Re: Error in factories.py in py4web?

2020-02-15 Thread Massimo Di Pierro
A mistake. Thanks for fixing it. :-) On Thursday, 13 February 2020 15:09:03 UTC-8, Luca wrote: > > In the class ActionFactory, there's the code below. Is that an error? I > don't think requires_login is in the proper place? Maybe I don't > understand. > > def put(self, path=None,

[web2py] Re: py4wb simplification

2020-02-15 Thread Massimo Di Pierro
They they should be added @autneticated and @unauthenticated are defined in common.py The @unauthenticated decorator automatically applys fixtures: db, auth, session, T. exposes the action with user /{function_name} and defaults to template {function_name}.html (very much like web2py does)

[web2py] Re: web2py 2.18.5: LOAD bugs?

2020-02-15 Thread Massimo Di Pierro
works for me. can you try print vars and URL(vars=vars)? On Monday, 10 February 2020 18:41:54 UTC-8, Toan Le wrote: > > Controller: > def test(): > return H3("Hello") > > def grid(): > tablename = request.args(0) or "auth_user" > if not tablename in db.tables: raise HTTP(403) >

[web2py] py4web: login and redirect to index

2020-02-15 Thread Martin Weissenboeck
Next question: I have added a new function to controllers.py: @authenticated() def index*1*(): user = auth.get_user() message = T("Hello *1*{first_name}".format(**user)) return dict(message=message, user=user) A call of 127.0.0.1:8000/myapp/index*1* requires a login. Ok, that is the

[web2py] py4web dashboard: username and password

2020-02-15 Thread Martin Weissenboeck
I have created an app "myapp" with the user - Username: john - Email: john@example.com - Password: 123 - First name: John - Last name: Doe (1) Change username: Now I want to change the username to "johndoe" Dashboard headline "App: myapp Database: db Table: auth_user" I