Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread AGRogers
Yeah, i dont really understand how web2py sends locals() etc back to the view and how that differs from JSON data. I just keep trying random things until it works :) On Tue, 23 Jun 2020 at 12:15, Pierre wrote: > thanks AG I will look into your suggestion. > Fiddling with the error,

Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread Pierre
thanks AG I will look into your suggestion. Fiddling with the error, found out that it's when reading back from sqlite that the error arise. It's like something from web2py doesn't like the format of my date in the field of the table. But at this time, i do not know how to tell

Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread AGRogers
Hi I use this code to solve this problem: result = json.dumps(result, indent=4, sort_keys=True, default=str) Don't know what it does but it solves my problem. I found it here: https://stackoverflow.com/questions/11875770/how-to-overcome-datetime-datetime-not-json-serializable On Wed, 17

Re: [web2py] How to sort a smartgrid with your own custom sorted id list

2020-06-22 Thread AGRogers
The only thing that comes to mind is to put your sort data into the database so you have something to sort on. If it is a single user app then it's easy - add a new column called sortid and put your custom sort order their. Multi user needs a second table to join on which might mess with smart

Re: [web2py] No module named error

2020-06-22 Thread Dave S
On Monday, June 22, 2020 at 5:13:46 AM UTC-7, patito feo wrote: > > Hi, > > I have done every recommended guide iv seen. Same error. > > Every time i saved the .py module file same message shows on top of the > editor. > > That's the editor/IDE shipped with web2py? (When you save a file, it

[web2py] Re: We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

2020-06-22 Thread Dave S
On Monday, June 22, 2020 at 2:07:32 AM UTC-7, Davidiam wrote: > > Sorry, I thought the post on top was only for me, I didn't know it was for > everyone :S > I think the GG form is unclear, and I wouldn't mind if they came up with a different wording, or moved that option to the hamburger

[web2py] Re: We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

2020-06-22 Thread Dave S
On Monday, June 22, 2020 at 2:10:35 AM UTC-7, Davidiam wrote: > > UPDATE : I managed to find the solution so I will post it here for any > others that have the same issue : > > We had to install a new ODBC driver and to modify the MS SQL connection > string. > > Thank you, followups are good

Re: [web2py] How to call other (and retrieve data/dictionnary ... ) web2py applications from within a web2py application

2020-06-22 Thread Laurent Chambon
Yes Le lun. 22 juin 2020 à 16:34, António Ramos a écrit : > I guess only with http requests > > L c escreveu em seg, 22/06/2020 às 11:01 : > >> Hello, >> >> there is an item on this subject however the links do not work anymore. >> Is there a simple, functional recipe to this question. >>

Re: [web2py] How to call other (and retrieve data/dictionnary ... ) web2py applications from within a web2py application

2020-06-22 Thread António Ramos
I guess only with http requests L c escreveu em seg, 22/06/2020 às 11:01 : > Hello, > > there is an item on this subject however the links do not work anymore. Is > there a simple, functional recipe to this question. > Thank you in advance > PS: I've looked in the book and I can't find a clear

Re: [web2py] No module named error

2020-06-22 Thread patito feo
Hi, I have done every recommended guide iv seen. Same error. Every time i saved the .py module file same message shows on top of the editor. Thanks in advance, El domingo, 21 de junio de 2020, 11:46:39 (UTC-5), Ramos escribió: > > check here >

[web2py] How to call other (and retrieve data/dictionnary ... ) web2py applications from within a web2py application

2020-06-22 Thread L c
Hello, there is an item on this subject however the links do not work anymore. Is there a simple, functional recipe to this question. Thank you in advance PS: I've looked in the book and I can't find a clear answer. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

2020-06-22 Thread Davidiam
UPDATE : I managed to find the solution so I will post it here for any others that have the same issue : We had to instrall a new ODBC driver and to modify the MS SQL connection string. Old string : uri = mssql://DRIVER={SQL Server} New string : uri = mssql://DRIVER={ODBC

[web2py] Re: We use web2p 2.18.5 with MS SQL on Windows IIS 10. Recently a security patch on the server enforced stricter SSL rules and we can no longer use TLS 1.0 and 1.1. so it has to be TLS 1.2

2020-06-22 Thread Davidiam
Sorry, I thought the post on top was only for me, I didn't know it was for everyone :S On Saturday, June 20, 2020 at 4:16:33 AM UTC+2, Dave S wrote: > > > > On Thursday, June 18, 2020 at 10:44:53 PM UTC-7, Davidiam wrote: >> >> Good Morning, >> >> I would like to know what I would have to