[web2py] multiple form in 1 page using tab

2017-08-11 Thread 黄祥
is it possible to have multiple form in 1 page using tab? z tried it before but no luck (no error occured but the result is not expected) the result that should open the new browser tab didnt open, after submit it just return flash 'success' *e.g.* *controllers/default.py* def report(): query =

Re: {Disarmed} [web2py] Re: custom filter in grid

2017-08-11 Thread 黄祥
just an idea why not create the new field with the date type with default value = request.now? so that user can search through the new date field best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] 'gluon.contrib.pg8000.ProgrammingError'> ('ERROR', '42P07', 'relation “auth_user” already exists'

2017-08-11 Thread Anthony
I agree it would be better to use psycopg2, but that may not be the source of your issue. It looks like the database tables already exist, but your web2py installation doesn't know it so is attempting to create the tables again. You can temporarily set fake_migrate_all=True, which will generate

Re: [web2py] 'gluon.contrib.pg8000.ProgrammingError'> ('ERROR', '42P07', 'relation “auth_user” already exists'

2017-08-11 Thread Shazia Nusrat
So to use psycopg2 I just need to install postgres and use adaptor like: db = DAL('postgres://storage', pool_size=1, check_reserved=['all'], migrate=False) If I create a db with the user and db name with "storage" would it work like this? Please advise because this is the first time I will be

Re: [web2py] 'gluon.contrib.pg8000.ProgrammingError'> ('ERROR', '42P07', 'relation “auth_user” already exists'

2017-08-11 Thread Richard Vézina
Use : psycopg2 pg8000 has known issues... Richard On Fri, Aug 11, 2017 at 10:42 AM, wrote: > Hi, > > I am new user to web2py and I copied repo from an existing project from > AWS. With following settings I need to make it work on local server so I > can make few changes

[web2py] 'gluon.contrib.pg8000.ProgrammingError'> ('ERROR', '42P07', 'relation “auth_user” already exists'

2017-08-11 Thread shazianusra
Hi, I am new user to web2py and I copied repo from an existing project from AWS. With following settings I need to make it work on local server so I can make few changes but I am stuck at database error. Please guide me as I have little knowledge about how to drop tables and make it work. if

{Disarmed} [web2py] Re: custom filter in grid

2017-08-11 Thread Carlos Cesar Caballero Díaz
Sitfan, thanks for your answer, I know about that, but is annoying for the users to put datetime values twice and they are asking about use only the day, they don't need to filter in that grid by date and time, just by date. Greetings. El 10/08/17 a las 20:15, 黄祥 escribió: in grid search

Re: [web2py] pycharm and web2py - setup project

2017-08-11 Thread Richard Vézina
Kirill, I just try to create a new project and the autocompletion was working, so I guess the issue is limited to virtual environement... On Fri, Aug 11, 2017 at 9:44 AM, Richard wrote: > Good, could you maybe try with python 2.14.6 if it works, just to be sure >

Re: [web2py] pycharm and web2py - setup project

2017-08-11 Thread Richard
Good, could you maybe try with python 2.14.6 if it works, just to be sure that web2py 2.15.x series trigger the issue... I think they are just not aware of the web2py modifications (if it the rigth reason of the issue), they have a lot on their plate and yes I guess web2py support could maybe

[web2py] Change value of select

2017-08-11 Thread Simona Chovancová
I need to change selected option in the view, I know that to change input value I do it like this: {{form.element('input', _name='field')['_value'] = "new_value"}}, but how do I do this with select? Also, this needs to be done in view, not controller so I cannot use default='some_option'. Any

Re: [web2py] Re: update_or_insert question...

2017-08-11 Thread António Ramos
I just failed my exam :) Thank you Anthony 2017-08-10 20:25 GMT+01:00 Anthony : > > > 2017-08-10 18:06 GMT+01:00 António Ramos : >> >>> better explanation >>> >>> first execution >>> id=db.entities.update_or_insert( ((db.entities.type==5) & >>>