Re: [web2py] Error: prepared statement «pg8000_statement_0» already exists

2019-01-25 Thread Lisandro
Hi there! Finally I was able to solve the problem uninstalling psycopg2* and reinstalling psycopg2-binary. Still, I want to comment what happened, in case it helps others. A packages update broke the psycopg2 package in the server. Actually, the server ended up with two instances: psycopg2 and p

[web2py] Generate query based on other db table content

2019-01-25 Thread Jon Subscripted
Hi all, I having a weird problem. I'm clueless. I do not even know how to look it up in the manual. I'm trying to store in the database (training table) user defined configurations that will lead to specific queries (accessed through list_problems_by_training controller's default view). These conf

[web2py] Re: Generate query based on other db table content

2019-01-25 Thread Anthony
> > #- query generator based on db > def get_training_query(training_id): > training = db.training[training_id] > player_query = player[training.player] > color_query = color[training.color] > query_total = None > for q in [player_query,color_query]: > if q is None

[web2py] integrate with google contact to send broadcast message

2019-01-25 Thread 黄祥
is there a way to integrate with google contact to send broadcast message (sms and whatsapp) and record it in database? any hints to achieve it with web2py? thx and best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

Re: [web2py] Re: Generate query based on other db table content

2019-01-25 Thread Jon Subscripted
Ups!! Yes, you're right. Thanks, Jon. On Fri, Jan 25, 2019 at 10:00 PM Anthony wrote: > #- query generator based on db >> def get_training_query(training_id): >> training = db.training[training_id] >> player_query = player[training.player] >> color_query = color[training.color] >