[web2py] Right use of IS_IN_DB and its "_and" parameter

2016-01-04 Thread Marcelo Huerta
I have the following definition in a table referencing the auth_user table. I try to create a table of VALOR_ESTADOS = ( 'inactivo', 'activo', 'vacaciones', 'desarrollo', 'edición', 'otro', ) db.define_table('estado', Field ('evaluador',

Re: [web2py] Scheduler Tasks show TICKER: error assigningt task (0) and task never start

2016-01-21 Thread Marcelo Huerta
> everything works fine with latest stable + postgresql 9.4 + psycopg2 > on win7. I'd say the fault could be a faulty web2py installation or at the > very least a driver issue (try to upgrade to the latest) And that was exactly it. I upgraded to the latest psycopg2 and the error stopped

Re: [web2py] Scheduler Tasks show TICKER: error assigningt task (0) and task never start

2016-01-20 Thread Marcelo Huerta
Niphlod decía, en el mensaje "[web2py] Re: Scheduler Tasks show TICKER: error assigningt task (0) and task never start" del 20/1/2016 17:42:40: > all of the sudden or you just started it ? No, I just incorporated the Scheduler to my application. Previously I wasn't using it. It never worked from

[web2py] Re: Scheduler Tasks show TICKER: error assigningt task (0) and task never start

2016-01-20 Thread Marcelo Huerta
> > I'm having the same issue with a PostgreSQL 9.4 backend on Windows 7. > Python 2.7.10 (32 bits) web2py: Version 2.13.4-stable+timestamp.2015.12.26.04.59.39 2016-01-20 17:34:33,809 - web2py.scheduler.RALF#2436 - ERROR - TICKER: error assigning tasks (0) 2016-01-20 17:34:34,312 -

Re: [web2py] Re: web3py status

2016-10-31 Thread Marcelo Huerta
El jueves, 18 de agosto de 2016, 16:44:05 (UTC-3), Massimo Di Pierro escribió: > > It is possible. web3py is code name for experimental stuff. Mostly new > form/grid logic that will be backported to web2py. > > I read somewhere that you are thinking of ditching SQLFORM (and, I assume, the

[web2py] Re: "Show_if" and Field Validation

2017-04-10 Thread Marcelo Huerta
Maybe creating a validation function which checks the different values and depending on them fills the form.errors values when a validation error happens? Take a look to http://web2py.com/books/default/chapter/29/07/forms-and-validators#onvalidation -- Resources: - http://web2py.com -

[web2py] Re: Highlighting the fields that user can't leave blank

2017-04-17 Thread Marcelo Huerta
El miércoles, 12 de abril de 2017, 9:51:25 (UTC-3), Anthony escribió: > > First, don't use Crud, as it has been deprecated. Just use SQLFORM. > I guess the book should reflect this, then. It still says «One of the recent additions to web2py is the Create/Read/Update/Delete (CRUD) API on top of

Re: [web2py] KeyError ticket when I request a CSV/TSV in a grid with a Virtual Field

2017-03-13 Thread Marcelo Huerta
> Can you show us your table definition? db.define_table('contrib', Field('titulo', label=T('Title'), requires=IS_NOT_EMPTY(error_message=u'El título no puede estar vacío')), Field('autor', requires=IS_NOT_EMPTY( error_message=u'El autor no puede estar vacío')),

[web2py] KeyError ticket when I request a CSV/TSV in a grid with a Virtual Field

2017-03-07 Thread Marcelo Huerta
Running 2.14.6-stable+timestamp.2016.05.10.00.21.47 on Ubuntu and Windows 7, python 2.7 When I try to generate a CSV or TSV from a grid with a Virtual Field, I get a ticket with a KeyError. Traceback (most recent call last): File "F:\Prog\web2py\gluon\restricted.py", line 227, in restricted

[web2py] Re: how to optimize this query to get ids like [100,200,102,909] not [{'id':100,'id':200...}

2017-07-17 Thread Marcelo Huerta
El viernes, 14 de julio de 2017, 12:56:57 (UTC-3), Leonel Câmara escribió: > > The cleanest way is the little known and undocumented column: > > db(db.entities.type==5).select(db.entities.id).column() > > This needs to be added to the book... -- Resources: - http://web2py.com -

[web2py] Re: Type conversion for args/vars?

2017-05-11 Thread Marcelo Huerta
El jueves, 11 de mayo de 2017, 4:10:47 (UTC-3), Brendan Barnwell escribió: > > > number = convert(request.args[1]) > number = request.args(1, cast=int) > option = convert(request.vars['option']) > I'm not aware of anything in this case. -- Resources: - http://web2py.com -

[web2py] Re: mercurial

2017-09-04 Thread Marcelo Huerta
El sábado, 2 de septiembre de 2017, 1:23:07 (UTC-3), Massimo Di Pierro escribió: > > also we can assume git is already installed so it is a matter of calling > subprocess. I would take a patch to simplify the code. :-) > > What about people with other VCSs installed which would want to use

[web2py] Re: [ISSUE] can't see db from database administration menu

2017-11-02 Thread Marcelo Huerta
The error message seems to indicate that you're using web2py with Python 3. This seems to be a remaining issue pending the full compatibility of web2py with Py3: unicode is a builtin function of Python 2. El miércoles, 1 de noviembre de 2017, 20:59:32 (UTC-3), Арслан Ибатуллин escribió: > >

[web2py] Re: How to show conditional fields with multiple conditions

2018-05-09 Thread Marcelo Huerta
Untested, but, shouldn't you write the conditions as ((db.auth_user.insrrance_list == 'FIRE') or (db.auth_user.insrrance_list == 'Both')) ? (Notice the extra parentheses.) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

Re: [web2py] web2py with python3

2018-06-12 Thread Marcelo Huerta
You should probably download the source version and follow the indications in http://www.web2py.com/books/default/chapter/29/03/overview#Startup about the source distribution. That way you invoke web2py.py with whatever version of Python you want to use. -- Resources: - http://web2py.com -

Re: [web2py] Re: Getting Error ModuleNotFoundError: No module named 'urllib2'

2018-06-04 Thread Marcelo Huerta
2018-06-04 14:54 GMT-03:00 Suhas Jadhav : > > Yes, I say the documentation. But issues here is urllib2 works well from my > python console. The Python3 console? Unless you have done something weird, urllib2 cannot work in the Python3 console *because the module does not exist*. The proper

[web2py] Re: Getting Error ModuleNotFoundError: No module named 'urllib2'

2018-06-04 Thread Marcelo Huerta
El lunes, 4 de junio de 2018, 10:44:37 (UTC-3), Suhas Jadhav escribió: > > > web2py™ Version 2.16.1-stable+timestamp.2017.11.14.05.54.25 > > PYTHON Python 3.6.2 > > > Any solution or workaround? > Using proper Python3 code? Module urllib2 does not exist in Python 3. -- Resources: -

[web2py] Re: auth.messages.subject

2018-01-24 Thread Marcelo Huerta
El miércoles, 24 de enero de 2018, 15:47:50 (UTC-3), Mark Billion escribió: > > So, this does not work. Any way to set the subject line? (maybe Im just > missing it) > http://web2py.com/books/default/chapter/29/08/emails-and-sms#Sending-emails -- Resources: - http://web2py.com -

[web2py] Re: DIV(*[DIV(k, syntax - this is working but I'm trying to follow...

2018-01-30 Thread Marcelo Huerta
El martes, 30 de enero de 2018, 0:25:12 (UTC-3), wdtnh escribió: > > From the web2py manual, I've got the following working fine but I'm not > clear on the DIV(* notation? Not comfortable using a method that I don't > understand the syntax. I understand the DIV() built-in but the DIV(* part >

[web2py] Demo site pointed from About page is not working

2018-02-06 Thread Marcelo Huerta
The about page of the main web2py site (http://web2py.com/init/default/what) points to a demo page at http://www.web2py.com/demo_admin, but the demo is not working, it fails attempting to create a ticket but the "ticket number" is "unknown". Either the demo or the page should be fixed... --

[web2py] Re: wfastcgi on IIS ... no more wfastcgi.py script?

2018-02-14 Thread Marcelo Huerta
El viernes, 18 de diciembre de 2015, 5:01:02 (UTC-3), Massimo Di Pierro escribió: > > Could you put this in the book? Thanks Tim. > > > I think that in spite of your request this has not yet been updated in the book. I still see a mention of a script called "wfasctgi.py" (sic), and nothing

[web2py] Search for list:string values in grid search?

2018-08-14 Thread Marcelo Huerta
Is it possible at all to search for values contained in fields defined as list:string in the grid search dialog? -- 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

Re: [web2py] Search for list:string values in grid search?

2018-08-24 Thread Marcelo Huerta
Anthony, thank you for your message. I will work from the information you gave, but I just wanted to say something regarding to a portion of the message: > Finally, note that if you simply enter a string in the search box and > click> "Search" (i.e., don't use the advanced search widget), it

[web2py] Re: Search for list:string values in grid search?

2018-08-22 Thread Marcelo Huerta
El martes, 14 de agosto de 2018, 10:59:53 (UTC-3), Marcelo Huerta escribió: > > Is it possible at all to search for values contained in fields defined as > list:string in the grid search dialog? > Anyone? -- Resources: - http://web2py.com - http://web2py.com/book (Documenta

[web2py] Re: Why not to mention support to Python3 on the official sites main page?

2018-07-17 Thread Marcelo Huerta
El lunes, 16 de julio de 2018, 9:55:01 (UTC-3), Ari Lion BR Sp escribió: > > Hi, > > I wonder here why Python3 support is not mentioned at the official > web2py's website? > > I also wonder this. I think it might be because web2py hasn't been 100% in Python3? This is one of the issues which

Re: [web2py] Re: Why not to mention support to Python3 on the official sites main page?

2018-07-17 Thread Marcelo Huerta
El mar., 17 jul. 2018 a las 13:54, Ari Lion BR Sp () escribió: > Thanks Marcelo Huerta / Anthony. > > Do you have tested python3? > ​I don't have the infrastructure to perform testing best performed by the development team...​ > > I can testify that perfomance improoves a

[web2py] Re: problem export virtual field to CSV using grid

2018-04-18 Thread Marcelo Huerta
I have also found the same problem. -- 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 subscribed to the Google

[web2py] Re: broken inframe video on manual web page

2018-10-16 Thread Marcelo Huerta
El domingo, 14 de octubre de 2018, 12:00:30 (UTC-3), Nico Zanferrari escribió: > > Hi, > it seems that there is a missing reference on the online web2py manual at > http://www.web2py.com/init/default/documentation . > There is a missing video >

[web2py] Re: What are you use with web2py.

2018-11-08 Thread Marcelo Huerta
My editor is Sublime Text 3. It's really fantastic, responsive and very configurable, with an interesting range of plugins. AS VCS I use Fossil . It can't really be beaten for simplicity and easy of configuration. Your repositories can be self-hosted with little fuss.

[web2py] Re: Bug in tools.py

2018-12-12 Thread Marcelo Huerta
Please open your nearest Python interpreter and type at the ">>> " prompt: help("".strip) -- 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

Re: [web2py] Help needed with web2py-book app

2018-12-03 Thread Marcelo Huerta
El sábado, 24 de noviembre de 2018, 19:48:32 (UTC-3), Nico Zanferrari escribió: > > I'm proud to announce that I've finished the work, and now the web2py book > is python3 compatible, as with PR #395 > It was a hard work for > me, but I've

[web2py] Re: Send form data as email

2018-12-03 Thread Marcelo Huerta
El martes, 27 de noviembre de 2018, 7:54:40 (UTC-3), 黄祥 escribió: > > think you can put mail.send() method in form.process() method > > I think it's probably best to queue the email sending in the scheduler, to avoid unresponsiveness in the page. -- Resources: - http://web2py.com -

[web2py] Re: default search string in SQL.grid

2018-09-13 Thread Marcelo Huerta
El jueves, 13 de septiembre de 2018, 8:10:48 (UTC-3), Matthew J Watts escribió: > > Hello all > > Is there a way to pre populate the 'search field' of the SQLFORM.grid? > > > In your URL to the function containing the grid, you can pass the search string in the vars dictionary. Just assign it

[web2py] Re: Search for list:string values in grid search?

2018-09-15 Thread Marcelo Huerta
El jueves, 23 de agosto de 2018, 23:08:02 (UTC-3), Anthony escribió: > > On Tuesday, August 14, 2018 at 9:59:53 AM UTC-4, Marcelo Huerta wrote: >> >> Is it possible at all to search for values contained in fields defined as >> list:string in the grid search dialog? >&

Re: [web2py] web3py again....

2019-03-28 Thread Marcelo Huerta
El jueves, 28 de marzo de 2019, 6:57:08 (UTC-3), José L. escribió: > > >- sqlform and grid are one of the key points for web2py. It's one of >the main reasons to use it instead of other frameworks as development is >really quick. However I think nowadays a backport from web2py is not

[web2py] Re: hidden field on CRUD

2019-02-28 Thread Marcelo Huerta
El martes, 26 de febrero de 2019, 18:16:15 (UTC-3), Dave S escribió: > > > Also look at 3rd party display tools like DataTables (datatables.net), > which is highly recommended in this list. (added in edit) > > Are there any examples of usage of DataTables with web2py? -- Resources: -

[web2py] Re: Fresh install - ImportError: cannot import name Cookie

2019-03-02 Thread Marcelo Huerta
El jueves, 28 de febrero de 2019, 18:55:13 (UTC-3), Leonel Câmara escribió: > > Most of compat stuff got moved to pydal but the version in the release > doesn't have the version with the pydal with the compat stuff there. > It's the latest pydal supposed to have the moved components? Because I

[web2py] Re: New International Telegram Support Group

2019-03-20 Thread Marcelo Huerta
El martes, 19 de marzo de 2019, 15:49:34 (UTC-3), Ari Lion BR Sp escribió: > > > Now I see a new link to this group: > https://t.me/web2py_world > > > Joined! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Update text for GRID buttons - View/Edit etc

2019-03-12 Thread Marcelo Huerta
El martes, 12 de marzo de 2019, 11:55:58 (UTC-3), Sarbjit escribió: > > Hello, > > I want to change the default text of the buttons visible in SQLFORM.GRID. > I am using the following code, but it is not updating the text > > grid.element(_title='View')['innerHTML']='Details' > > Any idea

[web2py] Re: Databese error in registration process

2019-03-12 Thread Marcelo Huerta
El martes, 12 de marzo de 2019, 4:13:31 (UTC-3), Константин Комков escribió: > > Maybe something do not work in that string, but before it work without > errors and now I have problem with only one user and I see that 20 users > was be registrated without errors after him also? > >

[web2py] Re: fixing .table appears corrupted on a compiled application

2019-02-05 Thread Marcelo Huerta
El domingo, 3 de febrero de 2019, 18:19:34 (UTC-3), Dave S escribió: > > > Back-ups are the nectar of the gods (nodding toward Greek mythonlogy) > > >>> Versioning systems for code, more so. Mostwanted, if you don't want to start with something heavy and unwieldy as git, at the very least try

[web2py] Re: database queries

2019-04-11 Thread Marcelo Huerta
El jueves, 11 de abril de 2019, 10:48:14 (UTC-3), learth...@gmail.com escribió: > > Hello everybody, > Nobody can help me to solve my problem ? :( > > If you don't show what effort have you made to try to solve the problem, basically you are asking that people on the internet do this for you,

[web2py] Re: Web3py

2019-06-19 Thread Marcelo Huerta
El viernes, 14 de junio de 2019, 11:32:58 (UTC-3), Massimo Di Pierro escribió: > > Be careful that you can no longer change attributes everywhere you like as > in: > > db.tablename.fieldname.readable = False > > In web2py this is ok. In web3py this is not safe. Attributes must be > global. The

[web2py] Re: Example in Celery for scheduling in py4web ?

2019-11-06 Thread Marcelo Huerta
El miércoles, 6 de noviembre de 2019, 1:59:06 (UTC-3), Ruslan Gareev escribió: > > Hello. You can google something like: "python celery queue". :) > Har har. I wanted an example specifically in the context of web2py because I cannot make sense of them seeing them in other contexts. > But

[web2py] Re: Scheduler for py4web ?

2019-11-05 Thread Marcelo Huerta
El jueves, 31 de octubre de 2019, 0:23:30 (UTC-3), Massimo Di Pierro escribió: > > No. The fact is, it does not need it. py4web is does not have the problem > of a custom environment. apps are modules that can be imported. Celery > works great with py4web and therefore I recommend using that

[web2py] Re: File chooser dialog

2020-02-05 Thread Marcelo Huerta
El martes, 4 de febrero de 2020, 19:03:01 (UTC-3), jim kaubisch escribió: > > I need to upload videos to YouTube. I do NOT want to also upload those > files to the web2py uploads mechanism > If I use a "normal" upload field I get a dialog to choose a file . How do > I access that dialog for a

[web2py] Re: Kaspersky Internet Security says http://www.web2pyslices.com/home?content<...> is a phishing site.

2020-02-05 Thread Marcelo Huerta
El martes, 4 de febrero de 2020, 17:28:12 (UTC-3), jim kaubisch escribió: > > I'm surprised. Does this make sense to anyone else? > > *It goes on to say ...* > > > *Blocked by Web Anti-Virus* > > Reason: phishing link > Detection method: databases > Cisco Web Security Virtual Appliance reports

[web2py] web2py / py4web in pypi.org

2020-02-04 Thread Marcelo Huerta
Are there plans to include the latest versions of the frameworks in pypi.org? I see that pypi.org has a web2py 2.1.1. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

Re: [web2py] Re: web2py / py4web in pypi.org

2020-02-10 Thread Marcelo Huerta
Well, there is an old package in https://pypi.org/project/web2py/, maybe it should be removed? -- 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

[web2py] Re: What’s the timelines for py4web?

2019-12-23 Thread Marcelo Huerta
El domingo, 15 de diciembre de 2019, 18:17:11 (UTC-3), Massimo Di Pierro escribió: > > My plan is to spend the Christmas vacation making sure it works with > Python 3.8, adding an internationalization UI, and fixing a few bugs with > error reporting. So by Dec 31. > Complete the core