Search

Clear search

Close search

Main menu

Google apps

web2py-users

1–30 of 34904

0 selected

mostwanted, Jim S5

8/2/20

solving <type 'exceptions.KeyError'> '\x00'

Thank you Jim, so much On Saturday, August 1, 2020 at 5:08:22 PM UTC+2, Jim S wrote: I am definitely

unread,

solving <type 'exceptions.KeyError'> '\x00'

Thank you Jim, so much On Saturday, August 1, 2020 at 5:08:22 PM UTC+2, Jim S wrote: I am definitely

8/2/20

Davidiam, … Dave S8

6/22/20

We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

On Monday, June 22, 2020 at 2:07:32 AM UTC-7, Davidiam wrote: Sorry, I thought the post on top was

unread,

We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

On Monday, June 22, 2020 at 2:07:32 AM UTC-7, Davidiam wrote: Sorry, I thought the post on top was

6/22/20

3/18/20

py4web GAE db datastore connection

Hi, I have deployed an app in GAE and works fine with these db settings in settings.py: # db settings

unread,

py4web GAE db datastore connection

Hi, I have deployed an app in GAE and works fine with these db settings in settings.py: # db settings

3/18/20

2/22/20

select for list:integer, but in a specific position

And a second version with SUBSTR def operator_field_starts(field, first_int, query_env={}): '

unread,

select for list:integer, but in a specific position

And a second version with SUBSTR def operator_field_starts(field, first_int, query_env={}): '

2/22/20

12/17/19

Accessing Postgres server from a secondary docker container without db.py

How do I do connect to a prostgres server using PyDAL but without a db.py in the secondary container

unread,

Accessing Postgres server from a secondary docker container without db.py

How do I do connect to a prostgres server using PyDAL but without a db.py in the secondary container

12/17/19

Jurgis Pralgauskis, Val K2

11/28/19

web2py for (R)OLAP (pivoting)?

Hi !, you can pass sql expressions to select() : .select(db.tbl.field, 'SUM(sometbl.somefield)

unread,

web2py for (R)OLAP (pivoting)?

Hi !, you can pass sql expressions to select() : .select(db.tbl.field, 'SUM(sometbl.somefield)

11/28/19

10/18/19

Validator IS_NOT_IN_DB not working | web2py

Wow, that's actually how it works! Thank you very much! Am Freitag, 18. Oktober 2019 12:32:17 UTC

unread,

Validator IS_NOT_IN_DB not working | web2py

Wow, that's actually how it works! Thank you very much! Am Freitag, 18. Oktober 2019 12:32:17 UTC

10/18/19

9/21/19

Checking the database items and seeing if they satisfy the condition before taking an action

What i want to achieve is to disable the quantity button in my shopping application that allows

unread,

Checking the database items and seeing if they satisfy the condition before taking an action

What i want to achieve is to disable the quantity button in my shopping application that allows

9/21/19

Davidiam, Val K4

9/12/19

Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

We have looked in this further, and due to the autoincremented ID fields in the Auth tables, we are

unread,

Overiding the auth table ID fields to allow for release over pillars (Development, Acceptance, Production)

We have looked in this further, and due to the autoincremented ID fields in the Auth tables, we are

9/12/19

Ian W. Scott, … Massimo Di Pierro6

9/16/19

Help understanding memory use and selects

I would rewrite p_here = [p for p in cpaths if loc_id in db.steps[int(p['steps'][0])].

unread,

Help understanding memory use and selects

I would rewrite p_here = [p for p in cpaths if loc_id in db.steps[int(p['steps'][0])].

9/16/19

Attique Tecnologia

9/1/19

Encoding datetime and uft chars with json

Hello my friends. I have a problem with json, charset, and python date and time encoding. My goal is

unread,

Encoding datetime and uft chars with json

Hello my friends. I have a problem with json, charset, and python date and time encoding. My goal is

9/1/19

mostwanted, … Dave S5

8/14/19

A calculation gives <type 'exceptions.TypeError'> unsupported operand type(s) for -: 'str' and 'str'

Someone suggested that i try this: from datetime import datetime (datetime.strptime(r['

unread,

A calculation gives <type 'exceptions.TypeError'> unsupported operand type(s) for -: 'str' and 'str'

Someone suggested that i try this: from datetime import datetime (datetime.strptime(r['

8/14/19

Dave S, Val K10

8/13/19

Accessing some sum

https://github.com/web2py/pydal/issues/388

unread,

Accessing some sum

https://github.com/web2py/pydal/issues/388

8/13/19

7/20/19

DAL and temporary tables

Does the DAL have any built-in support for temporary tables? I'm thinking that the best I can do

unread,

DAL and temporary tables

Does the DAL have any built-in support for temporary tables? I'm thinking that the best I can do

7/20/19

mostwanted, … Dave S13

6/11/19

A schedule automatic delete from Database

Thanks for the elaborate explanation Dave, really means a-lot. On Tuesday, June 11, 2019 at 5:20:13

unread,

A schedule automatic delete from Database

Thanks for the elaborate explanation Dave, really means a-lot. On Tuesday, June 11, 2019 at 5:20:13

6/11/19

5/30/19

web2py belongs if none

why not just: # start to form query: q = db.counters.c_date >= datum_od if ...: # continue to form

unread,

web2py belongs if none

why not just: # start to form query: q = db.counters.c_date >= datum_od if ...: # continue to form

5/30/19

8/28/19

On Tuesday, August 20, 2019 at 10:14:17 PM UTC-7, Dave S wrote: On Tuesday, August 13, 2019 at 2:46:

unread,

On Tuesday, August 20, 2019 at 10:14:17 PM UTC-7, Dave S wrote: On Tuesday, August 13, 2019 at 2:46:

8/28/19

5/18/19

why am I getting "duplicate key value violates unique contraint"?

On Friday, May 17, 2019 at 3:57:39 PM UTC-7, Dave S wrote: As mentioned in another thread, I recently

unread,

why am I getting "duplicate key value violates unique contraint"?

On Friday, May 17, 2019 at 3:57:39 PM UTC-7, Dave S wrote: As mentioned in another thread, I recently

5/18/19

Gilad Hoshmand2

5/14/19

gluon.contrib.pymysql.err.Error AssertionError('Protocol error, expecting EOF',)

Solved. The problem was that I was addressing 'single_value_field' without the context of the

unread,

gluon.contrib.pymysql.err.Error AssertionError('Protocol error, expecting EOF',)

Solved. The problem was that I was addressing 'single_value_field' without the context of the

5/14/19

João Matos, Anthony4

4/16/19

Is it possible to update a Rows object with another Rows object?

Thanks Anthony. I found out about belongs after posting. terça-feira, 16 de Abril de 2019 às 21:51:03

unread,

Is it possible to update a Rows object with another Rows object?

Thanks Anthony. I found out about belongs after posting. terça-feira, 16 de Abril de 2019 às 21:51:03

4/16/19

4/16/19

Does anyone know if web2py supports the IN operator in a query?

The solution is .belongs() http://web2py.com/books/default/chapter/29/06/the-database-abstraction-

unread,

Does anyone know if web2py supports the IN operator in a query?

The solution is .belongs() http://web2py.com/books/default/chapter/29/06/the-database-abstraction-

4/16/19

João Matos, … Lovedie JC9

4/10/19

The support of MongoDB is still experimental?

Thanks. quarta-feira, 10 de Abril de 2019 às 18:57:11 UTC+1, Lovedie JC escreveu: ON the localhost #

unread,

The support of MongoDB is still experimental?

Thanks. quarta-feira, 10 de Abril de 2019 às 18:57:11 UTC+1, Lovedie JC escreveu: ON the localhost #

4/10/19

David Manns, … Massimo Di Pierro12

4/9/19

Custom validator broken in 2.18.4, working in 2.17.2

The original version works with 2.18.5 Thank you! On Thursday, April 4, 2019 at 4:52:37 PM UTC-4,

unread,

Custom validator broken in 2.18.4, working in 2.17.2

The original version works with 2.18.5 Thank you! On Thursday, April 4, 2019 at 4:52:37 PM UTC-4,

4/9/19

4/2/19

Return random row on left join in one to many

Hi, I have two tables: `tx` contains a set of named objects and then `tx_vals` contain 0 to many

unread,

Return random row on left join in one to many

Hi, I have two tables: `tx` contains a set of named objects and then `tx_vals` contain 0 to many

4/2/19

João Matos, … Anthony19

3/25/19

Does web2py/DAL allow for creating atomic operations (begin transaction/end transaction)?

@John and @Anthony Thanks for your time. @John I disagree with you about the corner thing. With

unread,

Does web2py/DAL allow for creating atomic operations (begin transaction/end transaction)?

@John and @Anthony Thanks for your time. @John I disagree with you about the corner thing. With

3/25/19

João Matos, Leonel Câmara3

3/20/19

When using SQLite does web2py use the older rollback-mode transaction mechanism or the newer WAL?

Thanks. quarta-feira, 20 de Março de 2019 às 23:16:46 UTC, Leonel Câmara escreveu: Looking at: https:

unread,

When using SQLite does web2py use the older rollback-mode transaction mechanism or the newer WAL?

Thanks. quarta-feira, 20 de Março de 2019 às 23:16:46 UTC, Leonel Câmara escreveu: Looking at: https:

3/20/19

João Matos, … Anthony10

5/6/19

I would like to log of all SQL commands web2py sends to SQLite. Is it possible?

Logger is defined here: https://github.com/web2py/pydal/blob/master/pydal/base.py#L254 Debug logging

unread,

I would like to log of all SQL commands web2py sends to SQLite. Is it possible?

Logger is defined here: https://github.com/web2py/pydal/blob/master/pydal/base.py#L254 Debug logging

5/6/19

William, Leonel Câmara3

3/1/19

Web2py freezes when inserting rows. Problem seems to be database connection limit per application.

Ok I have somehow fixed this by adding "enable-threads = true" to my uwsgi ini file. Just

unread,

Web2py freezes when inserting rows. Problem seems to be database connection limit per application.

Ok I have somehow fixed this by adding "enable-threads = true" to my uwsgi ini file. Just

3/1/19

Lisandro, … Massimiliano10

1/25/19

Error: prepared statement «pg8000_statement_0» already exists

Hi there! Finally I was able to solve the problem uninstalling psycopg2* and reinstalling psycopg2-

unread,

Error: prepared statement «pg8000_statement_0» already exists

Hi there! Finally I was able to solve the problem uninstalling psycopg2* and reinstalling psycopg2-

1/25/19

mostwanted, … Anthony3

12/2/18

Using a value of one table as a default value of another table

The default argument can be a function, but it does not have access to the other fields being

unread,

Using a value of one table as a default value of another table

The default argument can be a function, but it does not have access to the other fields being

12/2/18