[web2py] Re: Using distinct with null

2020-01-14 Thread Massimo Di Pierro
you can mix and match DAL with SQL so just replace (a_wlp2.SUBSPC tt_main.SUBSPC) with "a_wlp2.SUBSPC *IS NOT DISTINCT FROM* tt_main.SUBSPC" should work. On Tuesday, 14 January 2020 04:39:38 UTC-8, Константин Комков wrote: > > Hello! > I have that query: > Firebird SQL > SELECT >

[web2py] Re: Cookie policy plugin

2020-01-14 Thread Massimo Di Pierro
I like this one: window.addEventListener("load", function(){window.cookieconsent.initialise({"palette": {"popup": {"background": "#000"},"button": {"background": "#f1d600"}}})}); On Sunday, 12 January 2020 02:54:21 UTC-8, Jonsubs wrote: > > Hi everyone, > Is there some easy way or specific

[web2py] Re: Why not updating this list? web2py-appliances

2020-01-14 Thread Massimo Di Pierro
true. those are apps are very old. not sure they should still be linked. On Wednesday, 8 January 2020 21:53:20 UTC-8, Dave S wrote: > > > > On Wednesday, January 8, 2020 at 5:07:26 AM UTC-8, Ari Lion BR Sp wrote: >> >> Hi There, >> >> In order to get more publicity, Why not updating this list

[web2py] Re: web2py broken with Python 3.8

2020-01-14 Thread Massimo Di Pierro
Works for me right now. On Monday, 6 January 2020 14:41:42 UTC-8, Woody wrote: > > Any update on when web2py will be compatible with Python 3.8? > > On Sunday, December 8, 2019 at 2:59:49 AM UTC-5, Massimo Di Pierro wrote: >> >> Both web2py and py4web are currently incompatible with python 3.8

Re: [web2py] web2py and py4web - single signon between the two

2020-01-14 Thread Massimo Di Pierro
yes. that is a priority. On Sunday, 5 January 2020 13:28:10 UTC-8, Carlos Cesar Caballero wrote: > > Maybe implementing a CAS server for py4web... But I am not sure right now > what will be the recommended way for implementing > modules/components/plugins in py4web... > > El vie., 3 de enero

[web2py] Re: pysimplesoap & py4web

2020-01-14 Thread Massimo Di Pierro
yes. I think it would be a very good exercise to port the @service.soap decorator defined in web2py/gluon/tools.py to py4web On Saturday, 4 January 2020 14:38:02 UTC-8, LUC wrote: > > Dear team, does anyone know if the py4web will support pysimplesoap? > -- Resources: - http://web2py.com -

[web2py] URL redirect to www

2020-01-14 Thread Zuhaib Butt
how i can add www with the url in web2py please if you have any idea let me know and please tell me where we can add file direction / route -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Web2py or py4web for a brand new project

2020-01-14 Thread Andrew Rogers
Hi Is the documentation for web2py still mostly relevant for py4web? Thanks Andrew On Thursday, 12 December 2019 20:47:05 UTC+6:30, icodk wrote: > > Should I use Web2py or py4web for a brand new project ? > What is still missing from py4web ? > Can I debug with pycharm ? > I need all the

[web2py] Re: Web2py or py4web for a brand new project

2020-01-14 Thread Andrew Rogers
Thanks for that info. I am about to start a new project which is also my first. So i would like to go with py4web. But i am nervous about not having good documentation for py4web. Is the old documentation and videos etc that you have made (which are great - thanks) still mostly relevant? On

Re: [web2py] Re: Is there a way to style a SQLFORM.grid view page

2020-01-14 Thread Geordanis Baño Vega
from de web2py pdf manual: {{=form.custom.begin}} Image name: {{=form.custom.widget.name}} Image file: {{=form.custom.widget.source}} Click here to upload: {{=form.custom.submit}} {{=form.custom.end}} El mié., 8 ene. 2020 a las 14:40, Ari Lion BR Sp () escribió: > I use a trick - but I think

[web2py] Help with request.args() and SQLFORM.grid(). Error 404

2020-01-14 Thread Juan Gutiérrez
This sounds crazy but I'm getting an error 404 when using in the same function this lines together: test = db.test(request.args(0,cast=int, otherwise=URL('index'))) or redirect(URL('index')) grid = SQLFORM.grid(db(db.test.id == 2), deletable=False, editable=True) When I comment either one of

Re: [web2py] blob fields with PostGres

2020-01-14 Thread Dave S
On Sunday, January 12, 2020 at 9:36:14 AM UTC-8, Carlos Correia wrote: > > Às 22:51 de 10/01/20, Dave S escreveu: > > For web2py/pydal when the backend is PostGres, are blob fields > translated to > > bytea or to large object? > > > > If bytea, does the adapter check that the value being

[web2py] Re: Problem with oracle query

2020-01-14 Thread 'tomt' via web2py-users
Thanks for posting your solution. I ran into the same problem and probably wouldn't have figured it out without your post. - Tom On Monday, April 15, 2019 at 5:20:36 AM UTC-6, gliporace wrote: > > I think I found the problem: > the query is sent with the table name double-quoted: > > select

[web2py] Re: Remote database synchronization

2020-01-14 Thread Ari Lion BR Sp
Is it possible to catch each and every Dal Action and send it to a queue, in order to use the info to update another database (remote, which I want to update, assynchronously). Would I need to have a UUID to make it? Best regaqrds Ari Em segunda-feira, 13 de janeiro de 2020 09:17:02

[web2py] Using distinct with null

2020-01-14 Thread Константин Комков
Hello! I have that query: Firebird SQL SELECT a_wlp2.id, s_disc_names.FULL_NAME FROM tt_main JOIN a_groups ON (tt_main.GROUP_ID = a_groups.id) JOIN a_wlp2 ON ((a_groups.WLP = a_wlp2.WLP) AND (a_wlp2.SUBSPC *IS NOT DISTINCT FROM* tt_main.SUBSPC)) JOIN a_wlp2_distrib ON ((a_wlp2.id =