[web2py] Re: DAL sqlite vs postgresql: Row Orders are different?

2017-06-30 Thread Leonel Câmara
It's not just a characteristic of postgresql, if you want ordered results you should specify so, otherwise they may come unordered due to any of the many optimizations performed by the DB. It's easy to use orderby using web2py's DAL and well explained in the book: http://www.web2py.com/books/def

[web2py] DAL sqlite vs postgresql: Row Orders are different?

2017-06-30 Thread lyn2py
I ran my app on *sqlite* and things are working well, so I ported it over to *postgresql*... however I noticed one glaring difference in the results retrieved immediately... On sqlite, no matter how many times I edit an entry, for example, an entry with id==1, it will always be the first row on

[web2py] Re: Totally app-internal routing

2017-06-30 Thread Brendan Barnwell
On Thursday, June 29, 2017 at 8:27:01 AM UTC-7, Anthony wrote: > > You need to have at least a basic routes.py in the root /web2py folder, > but for application specific routing, you can also put a routes.py file in > the application folder (i.e., in /web2py/applications/myapp/). > Okay. . . but

[web2py] Web2py Error apache2 ubuntu server form two ports

2017-06-30 Thread Marco Antonio Castro Collazos
1073/5000 Good morning everyone I have the following problem: I have web2py installed on an ubuntu server with apache2. I have a local network with port 443 and an ip publish port 5043 When I enter my web2py application from the local network, and I navigate without problem. But the entry from

Re: [web2py] Re: function lazy_user at ...

2017-06-30 Thread Anthony
On Friday, June 30, 2017 at 11:45:37 AM UTC-4, Ramos wrote: > > Another problem or symptom is that the computed function need the record > update call to pass all the fields the computed function needs to access > otherwise does not execute. > > for example > > my record with id =1 > {"event":"

Re: [web2py] Re: function lazy_user at ...

2017-06-30 Thread António Ramos
Another problem or symptom is that the computed function need the record update call to pass all the fields the computed function needs to access otherwise does not execute. for example my record with id =1 {"event":"1","created_by":4,"status":21} this line db(db.entities.id==1).update(event="2

[web2py] How to debug via admin?

2017-06-30 Thread António Ramos
hi just toggled a breakpoint via admin Refreshed the app page and it hanged as expected. I go to admin and dont know how to trace the code. Any suggestion ? regards -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https:

[web2py] Re: user logout before ajax returns

2017-06-30 Thread Anthony
On Friday, June 30, 2017 at 7:19:49 AM UTC-4, Pierre wrote: > > hi everyone, > > in the w2p book we are advised to user-signature ajax urls but what's > happen if user logout and the ajax hasn't finished its job. > Should be OK as long as the Ajax controller gets called before the logout. Other

[web2py] Re: response.js after redirect

2017-06-30 Thread Anthony
On Thursday, June 29, 2017 at 6:05:02 PM UTC-4, Filipe Reis wrote: > > Ohh nice thinking, I forgot that I could do such thing :) > > Anyways I asked this in other thread but do you know something about this? > > How to use signature with web2py_component? (I changed web2py_ajax_page to > web2py_c

Re: [web2py] Re: function lazy_user at ...

2017-06-30 Thread António Ramos
My error again... during the computation i retieve from auth_membership the user_id i had to convert to int otherwise i would return a function Regard 2017-06-30 11:29 GMT+01:00 António Ramos : > this test code > > db(db.entities.id==473).update(status=21) > > does note trigger the computed fie

[web2py] user logout before ajax returns

2017-06-30 Thread Pierre
hi everyone, in the w2p book we are advised to user-signature ajax urls but what's happen if user logout and the ajax hasn't finished its job. Shall this be a special error case ? Also shall we pass *auth.user_id* in the ajax request params to make sure task is performed eventhough user would

Re: [web2py] Re: function lazy_user at ...

2017-06-30 Thread António Ramos
this test code db(db.entities.id==473).update(status=21) does note trigger the computed field on record 473 that takes status and does some computation Thank you 2017-06-29 14:13 GMT+01:00 António Ramos : > Solved again... > > Thank you > > 2017-06-29 14:03 GMT+01:00 Anthony : > >> if not