Re: [web2py] Re: Future of web2py

2018-11-19 Thread Richard Vézina
You are right, I found some that there wierd things occuring some times as the left side bar completly disappeared... My guess is that this is some glitches that may be existing for some browser/OS?? I think from my standpoint that the issue is that the framework is Signle app vue... I am not

[web2py] Divider in

2018-11-19 Thread Jitun John
web2py 2.16.1 broke LI(_class="divider"), in response.menu I followed Leonel Câmara, added BS4MENU in menu.py and "LI(_class='dropdown-divider')" in the response.menu but the navbar is lost. Just wondering if we have any way to add divider in menu. -- Resources: - http://web2py.com -

[web2py] .tar.gz files get renamed to .gz on upload

2018-11-19 Thread Jordan Ladora
Hi, This is kind of a bug and kind of a feature, and I presume it would happen with any two-part file extension. When I upload a .tar.gz file into my app, w2p appropriately renames the file preserving the extension, but the problem is, w2p assumes the extension is .gz and not the entire

[web2py] Re: Problem with starting project

2018-11-19 Thread Константин Комков
I solved problem. It's important steps for install: 1. Python 2.7.9 *x86* (I have instlled x64 before) 2. Then install fdb driver (in cmd writing C:/Python27/Scripts/pip install fdb) 3. Then download web2py source code like told Dave S and run web2py.py. As I thought problem was in that. I

Re: [web2py] Re: env

2018-11-19 Thread Manuele Pesenti
Hi Anthony, thanks for your replay. On 17/11/2018 16:01, Anthony wrote: What do you mean by "returns None"? I do not think the function env() can return None, so where are you seeing None? I see the string None in the browser when I try to access the controller. I guess the code exits in

[web2py] Selecting from SQLFORM grid generated using a join selects incorrect IDs

2018-11-19 Thread 'Francis Windram' via web2py-users
Hi All, I'm hitting an issue with the selectable field in SQLFORM.grid. I have a controller including a grid generated from a join on three tables as follows: applics_fields = ['first_name', 'last_name', 'email', 'rank', 'nerc_elig', 'cv', 'coverletter', 'refletter1',

[web2py] Re: how to set "arraysize" value for the DAL Oracle cursor ?

2018-11-19 Thread Thomas Klopf
Hi Massimo, thanks for the info! Please do you have more info about not converting to objects? On Sunday, September 2, 2018 at 10:51:21 PM UTC+2, Massimo Di Pierro wrote: > > You can with > > db = DAL('oracle:...) > db.connection.cursor.arraysize =10 > > But I suspect the problem is

[web2py] Location of SQLFORM.grid pagination code for "count (*)" ?

2018-11-19 Thread Thomas Klopf
Hi everyone, Please could someone point out how/where the pagination works with SQLFORM.grid? I found a bug with the Oracle driver, where queries will fail if you're trying to filter columns that aren't displayed in the 'fields' list passed to SQLFORM.grid(). Basically I need to get to the

Re: [web2py] Re: MongoDB

2018-11-19 Thread Lovedie JC
I've gone through the code and I haven't done any caching in selects but still getting the message. On Mon, 12 Nov 2018, 18:04 Leonel Câmara Don't use cache and cacheable in your selects. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > -

[web2py] Re: Web2py 2.27.2 missing pg8000 driver for postgresql databases

2018-11-19 Thread jonathan . clark
Happy to say all I had to do was pip install --user pg8000. On Sunday, 18 November 2018 18:46:35 UTC, jonatha...@whatho.net wrote: > > Hi, > > In the past I have successfully used driver pg8000 to access postgresql > databases via the DAL. I have a live application now using web2py 2.16.1 > and

[web2py] Re: Selecting from SQLFORM grid generated using a join selects incorrect IDs

2018-11-19 Thread Anthony
With joins, you have to specify the ID field explicitly: SQLFORM.grid(..., field_id=db.applics1.id) Anthony On Monday, November 19, 2018 at 4:48:14 AM UTC-5, Francis Windram wrote: > > Hi All, > > I'm hitting an issue with the selectable field in SQLFORM.grid. > > I have a controller including

Re: [web2py] Re: MongoDB

2018-11-19 Thread Anthony
web2py sets cacheable=True for queries it does in the IS_IN_DB validator as well as in SQLFORM.grid. Please open an issue about this. Anthony On Monday, November 19, 2018 at 8:22:21 AM UTC-5, Lovedie JC wrote: > > I've gone through the code and I haven't done any caching in selects but > still

[web2py] Re: Web2py 2.27.2 missing pg8000 driver for postgresql databases

2018-11-19 Thread Anthony
pg8000 was removed from web2py contrib (I think due to bugs/lack of maintenance). Anthony On Sunday, November 18, 2018 at 1:46:35 PM UTC-5, jonathan.cl...@whatho.net wrote: > > Hi, > > In the past I have successfully used driver pg8000 to access postgresql > databases via the DAL. I have a

[web2py] Re: Location of SQLFORM.grid pagination code for "count (*)" ?

2018-11-19 Thread Anthony
The code used by the grid to generate the DAL query is at https://github.com/web2py/web2py/blob/master/gluon/sqlhtml.py#L2351. Notice you can do: SQLFORM.grid (..., cache_count=my_custom_count_function) where my_custom_count_function takes the DAL Set object used by the grid to generate the

Re: [web2py] Re: MongoDB

2018-11-19 Thread Lovedie JC
how and where do I open this issue? Regards On Mon, 19 Nov 2018 at 17:46, Anthony wrote: > web2py sets cacheable=True for queries it does in the IS_IN_DB validator > as well as in SQLFORM.grid. Please open an issue about this. > > Anthony > > On Monday, November 19, 2018 at 8:22:21 AM UTC-5,

[web2py] Re: how to set "arraysize" value for the DAL Oracle cursor ?

2018-11-19 Thread Anthony
See https://groups.google.com/d/msg/web2py/1ULZttF2a-k/r5ZeDbTfAAAJ. You can start by setting cacheable=True to see if that helps, and then try the custom processor if it's still too slow. Anthony On Monday, November 19, 2018 at 7:53:25 AM UTC-5, Thomas Klopf wrote: > > Hi Massimo, thanks for

Re: [web2py] Re: MongoDB

2018-11-19 Thread Anthony
https://github.com/web2py/web2py/issues On Monday, November 19, 2018 at 10:08:52 AM UTC-5, Lovedie JC wrote: > > how and where do I open this issue? > Regards > > On Mon, 19 Nov 2018 at 17:46, Anthony wrote: > >> web2py sets cacheable=True for queries it does in the IS_IN_DB validator >> as

[web2py] Re: Selecting from SQLFORM grid generated using a join selects incorrect IDs

2018-11-19 Thread 'Francis Windram' via web2py-users
That works perfectly! Thank you very much On Monday, 19 November 2018 14:38:55 UTC, Anthony wrote: > > With joins, you have to specify the ID field explicitly: > > SQLFORM.grid(..., field_id=db.applics1.id) > > Anthony > > On Monday, November 19, 2018 at 4:48:14 AM UTC-5, Francis Windram wrote: