[web2py] Re: SQL NOT IN issue(belong)

2019-01-03 Thread Val K
Hi! `belongs` accepts list, tuple, SQL-string (that can be generated by `_select `) and in some cases it may be a `query` (see book for details) but you're trying to feed it with field-object On Thursday, January 3, 2019 at 11:39:34 AM UTC+3, Yann Dulondel wrote: > > > > Le mercredi 2

[web2py] Re: SQL NOT IN issue(belong)

2019-01-03 Thread Yann Dulondel
Le mercredi 2 janvier 2019 16:55:54 UTC+1, Yann Dulondel a écrit : > > Hi All > Happy new year 2019. > > I have an issue with SQL NOT IN > I tried to get a heater pad list(dropdown) in a form. > The heater must be related to user depot and not been used. > If they are used the heater id is set

[web2py] Re: private functions

2019-01-03 Thread Anthony
On Thursday, January 3, 2019 at 11:32:27 PM UTC-5, Vlad wrote: > Here is a quote from THE BOOK: "Functions that take arguments or start with a > double underscore are not publicly exposed and can only be called by other > functions." > > > What about functions that take an argument which has a

[web2py] private functions

2019-01-03 Thread Vlad
Here is a quote from THE BOOK: "Functions that take arguments or start with a double underscore are not publicly exposed and can only be called by other functions." What about functions that take an argument which has a default value specified (i.e. can be called without an argument)? Would

Re: [web2py] Re: modular web2py - need help

2019-01-03 Thread sandeep patel
@Stifan OS Windows 10, Python 3.6.6 The shell sign is indicated in *nix environment because I am using Git Bash CLI. Thanks SP On Thu, Jan 3, 2019 at 8:13 PM 黄祥 wrote: > pls provide your environment (os and python version), the log errors > indicate in windows but the shell sign is indicate in

Re: [web2py] Re: modular web2py - need help

2019-01-03 Thread 黄祥
pls provide your environment (os and python version), the log errors indicate in windows but the shell sign is indicate in *nix environment the step provided before tested in mac and also in run well in ubuntu n debian docker pull ubuntu docker run -it ubuntu /bin/bash docker pull debian

[web2py] Scheduler

2019-01-03 Thread fiubarc
Hello! I have configured the scheduler to start at server restart but it does not take the tasks that already exists in scheduler_task table. Then I have to delete them and reassign them every time I restart the server. These tasks should run once a day, every day Is there a better way to

Re: [web2py] Re: modular web2py - need help

2019-01-03 Thread sandeep patel
@Carlos Cesar, I am in error trap. :( I have done the same steps git clone --recursive https://github.com/web2py/web2py.git cd web2py git checkout modular cd gluon/packages/dal/ git checkout modular cd ../../../ python setup.py python web2py.py But I am still getting the same error. Please give

[web2py] Re: SQL NOT IN issue(belong)

2019-01-03 Thread Yann Dulondel
Thank for your answer. Ok i understand that this db((db.v_heatpad.id_depot==db.auth_user.id_depot)&(db.auth_user.id==auth. user.id)&(db.v_heatpad.padid==db.heatpad.id)) Create a where clause and belong does work with a full SQLcommande (Select from t1,t2 where .) [image:

Re: [web2py] Re: modular web2py - need help

2019-01-03 Thread Carlos Cesar Caballero Díaz
Hi, most of the compatibility imports where moved from gluon to pydal compat module, so, if web2py does not find the 'Cookie' module, is because it either is not imported in gluon or pydal, so, I think that you are not using the modular branch of pydal. Start the steps again as @sitfan post in

Re: [web2py] Re: modular web2py - need help

2019-01-03 Thread 黄祥
pardon, can't help further not using win env for the moment, but tested in python 3.6.6 work docker pull ubuntu docker run -it ubuntu /bin/bash apt update apt install -y curl bzip2 git curl -L -O -C - https: //repo.continuum.io/miniconda/Miniconda3-latest-Linux-x86_64.sh bash Miniconda*.sh