[web2py] [DAL] AttributeError: 'Expression' object has no attribute 'tablename'

2017-07-19 Thread lyn2py
How do I resolve this error? Traceback (most recent call last): File "/Users/web2py/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File "", line 83, in File "/Users/web2py/web2py/gluon/globals.py", line 422, in write

Re: [web2py] web2py 2.15.2 is OUT

2017-07-19 Thread 黄祥
found an error that the same code didn't throw an error in previous version 2.15.1 Traceback (most recent call last): File "/Users/MacBookPro/site/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File

[web2py] Re: Page with four LOAD components is too slow

2017-07-19 Thread Leonel Câmara
You are probably doing too much stuff. See if you can pre-compute stuff. For instance. Imagine you have a debate table, then you have a comment table that refers to the debate where the comment is made. If you want to show a list of debates with the comment count, then you will have to make

[web2py] Page with four LOAD components is too slow

2017-07-19 Thread Anthony
If you are using the default file based sessions, the first thing you can do is unlock the session within each component request if you don't need to write to the session: session.forget(response) Otherwise, each component must wait for the previous to load. Anthony -- Resources: -

[web2py] Not able to get html form1 values to controller default when html form 2 is submitted.

2017-07-19 Thread Anthony
When you submit a form, the browser only sends data from that form, not all forms on the page. If you need to include a field from another form, you will need to use some JavaScript. The code could copy the value form two into a hidden field of the same name in form one whenever the value in

[web2py] Re: app slow on pythonanywhere

2017-07-19 Thread Bernardo Leon
I am using now redis for session handling on the same machine of the webserver and got rid of big fcntl.flock lock. Thank you so much for your help! El martes, 18 de julio de 2017, 23:04:33 (UTC-5), Bernardo Leon escribió: > > Thank you for your answer, Indeed I am using several ajax requests

[web2py] Re: Can't log into the application if using redis for sessions

2017-07-19 Thread Bernardo Leon
Thank you so much! I've been as dumb as fry ;) Now I can log in without issues. El miércoles, 19 de julio de 2017, 9:41:03 (UTC-5), Leonel Câmara escribió: > > Nevermind I found your problem. You are connecting the Session after > instantiating Auth. You need to do it before as Auth checks

[web2py] Re: Display Image from Uploads Folder

2017-07-19 Thread Gabriel Paulini
My bad bro. I thought this group was web2py-brazil. Btw it worked ;) It helped me a lot even though it is a simple question. On Wednesday, July 19, 2017 at 9:50:30 AM UTC-3, Leonel Câmara wrote: > > Hey, > > In the future, please use English as this is an international board. > > By

Re: [web2py] Re: Help - Grid with left joins and sending arguments/variables to other functions

2017-07-19 Thread Jim S
We were all there once. Glad I was able to help. Part of the beauty of web2py is the community and the friendly help you can get on this group. -Jim On Wednesday, July 19, 2017 at 9:26:08 AM UTC-5, Matthew J Watts wrote: > > Great thanks Jim, that did it for me - it's hard being a beginner!!

[web2py] Re: Not able to get html form1 values to controller default when html form 2 is submitted.

2017-07-19 Thread Leonel Câmara
You don't have any input with name="duallistbox_demo" in the form that submits to companyexample, you do have one select with that name in the other form. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Can't log into the application if using redis for sessions

2017-07-19 Thread Leonel Câmara
Nevermind I found your problem. You are connecting the Session after instantiating Auth. You need to do it before as Auth checks stuff in the session on __init__ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: After update can't connect Oracle

2017-07-19 Thread Leonel Câmara
Yes the oracle fixes have not been merged in pyDAL yet. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are

Re: [web2py] Re: Help - Grid with left joins and sending arguments/variables to other functions

2017-07-19 Thread 'Matthew J Watts' via web2py-users
Great thanks Jim, that did it for me - it's hard being a beginner!! On Wed, Jul 19, 2017 at 2:09 PM, Jim S wrote: > I'd start first with changing this: > > links = [lambda ids: A('Download data set',_href=URL("default","down > load_dataset.csv",args=[ids.id]))] > > to this:

Re: [web2py] web2py 2.15.2 is OUT

2017-07-19 Thread BearXu
Thanks On 19 July 2017 at 07:25, Massimo Di Pierro wrote: > web2py 2.15.2 is OUT is includes a few major bug fixes to version 2.15.1. > Thanks Leonel for the quick fixes. > There a few other outstanding problems and they will be resolved in the > next week. > > For

[web2py] Re: After update can't connect Oracle

2017-07-19 Thread Вячеслав Анатольевич
In web2py 2.15.2 - error not fixed... I fixed myself but: File "D:\Web\server\web2py\gluon\packages\dal\pydal\adapters\oracle.py", line 40, in execute m = self.cmd_fix.match(command) AttributeError: 'Oracle' object has no

[web2py] Accessing all attributes for all SQLFORM grid rows

2017-07-19 Thread David Orme
Hi, I've got a controller that is serving up a searchable SQLFORM grid of some map locations along with a Leaflet map containing the locations. The underlying table looks like this: db.define_table('gazeteer', Field('location', 'string', unique=True), Field('type', 'string',

[web2py] Re: Can't log into the application if using redis for sessions

2017-07-19 Thread Bernardo Leon
Thank you for your answer, I installed redis as localhost and changed that line to use RConn() without parameters unfortunately I am still getting the same problem. If I run: redis-cli KEYS "*" I get 3 keys created 1) "w2p:sess:app:serial" 2) "w2p:sess:app:1" 3) "w2p:sess:app:id_idx" So I

[web2py] Re: Help - Grid with left joins and sending arguments/variables to other functions

2017-07-19 Thread Jim S
I'd start first with changing this: links = [lambda ids: A('Download data set',_href=URL("default","download_dataset.csv",args=[ids.id]))] to this: links = [lambda ids: A('Download data set',_href=URL("default","download_dataset.csv",args=[ids.MAIN.id ]))] When you add the

[web2py] Re: Display Image from Uploads Folder

2017-07-19 Thread Leonel Câmara
Hey, In the future, please use English as this is an international board. By default you have a download function in default.py and that's what you should use so instead of this: Do: Note that this fixes 2 problems you had. The probably wrong URL and the missing quotes around the html

[web2py] Not able to get html form1 values to controller default when html form 2 is submitted.

2017-07-19 Thread srinadhasomala
I need values of request.vars.duallistbox_demo when form "class="modal-content animate"" is submitted. At present i am getting the value as none for Here is My Code Html part Username Password serverip

[web2py] Display Image from Uploads Folder

2017-07-19 Thread Gabriel Paulini
Olá, Meu problema parece ser fácil mas sou iniciante em desenvolvimento para web, principalmente com web2py. Tenho uma tabela de aplicativos com os campos 'appNome' e 'appIcone'. No controlador *default *há uma função que faz um select dessa tabela e na view tenho um *for *que varre a tabela

[web2py] web2py 2.15.2 is OUT

2017-07-19 Thread Massimo Di Pierro
web2py 2.15.2 is OUT is includes a few major bug fixes to version 2.15.1. Thanks Leonel for the quick fixes. There a few other outstanding problems and they will be resolved in the next week. For new users 2.15.2 is still better than previous versions. For current users, please check it out

[web2py] Use nosql collections in web2py models

2017-07-19 Thread Michele Serra
Hi everyone, I wanted to ask a question about the use of a nosql database in web2py models, that is how I can build a document collection through the pydal create_table method, I know it is still in the experimental phase, but I really need it, By doing various experiments I noticed that using

[web2py] Help - Grid with left joins and sending arguments/variables to other functions

2017-07-19 Thread 'Matthew J Watts' via web2py-users
Hi all I'm having some problems trying to achieve the following I have a grid with left joins which selects a subset of entries in my database -(query between 3 tables) Once i get the desired result, i want to be able to set up links within the table that then send the id from each row

[web2py] Modules not reloading

2017-07-19 Thread Anthony
Is this Python 2 or 3? Does it work using __import__() instead of importlib? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message

Re: [web2py] Re: Modules not reloading

2017-07-19 Thread António Ramos
Got it Leonel. I´m just testing code. When i found the best way to solve my problem i will name it less horribly :) Regards António 2017-07-19 11:34 GMT+01:00 Leonel Câmara : > Well you are importing from ficheiros3.py (horribly named file btw) using > importlib,

[web2py] Re: Modules not reloading

2017-07-19 Thread Leonel Câmara
Well you are importing from ficheiros3.py (horribly named file btw) using importlib, track_changes works with the web2py custom importer so naturally it does not work for you. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: Modules not reloading

2017-07-19 Thread António Ramos
Any help??? 2017-07-18 15:42 GMT+01:00 António Ramos : > And if i change one of the functions i get the same "refresh" problem... > > 2017-07-18 14:58 GMT+01:00 António Ramos : > >> Hello in my db.py >> >> i have this >> >> from gluon.custom_import

[web2py] Re: Can't log into the application if using redis for sessions

2017-07-19 Thread Leonel Câmara
Probably something wrong here: rconn = RConn('[ip]', 6379 try without parameters: rconn = RConn() If this doesn't work you need to check which IP and port redis is actually listening on. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: color picker

2017-07-19 Thread Leonel Câmara
Andrea, lets get one thing clear, what's making input type='color' work is not web2py, it's the browser. IE11 and earlier do not support inputs for that type. You cannot do this without javascript. See: http://caniuse.com/#feat=input-color Note that the javascript I suggested you use is

[web2py] Re: color picker

2017-07-19 Thread Andrea Fae'
I'm sorry but it's Javascript. I prefer to define a field of web2py db. How to implement? Thank you very much Il giorno martedì 18 luglio 2017 21:57:00 UTC+2, Leonel Câmara ha scritto: > > You can use a polyfill such as this one > https://briangrinstead.com/blog/input-type-color-polyfill/ > > I