[web2py] Re: How can javascript reads a SQLFORM field which writable=False

2017-06-06 Thread Rudy
I just used the firefox inspector to see the source and spot the id and tag I need to get the non-writable field value, something like below: var quote_id = jQuery('#quotation_id__row').children("p")[0].innerHTML; Apologize for any bother, I am still learning a lot of stuffs eg. web2py,

[web2py] Re: Login page - Menu bar does not work

2017-06-06 Thread Anthony
Note, this has already been fixed in the master branch, so should be fine in the next release. Anthony On Tuesday, June 6, 2017 at 11:11:26 PM UTC-4, Anthony wrote: > > On Tuesday, June 6, 2017 at 4:13:26 PM UTC-4, Jordan Ladora wrote: >> >> I notice the same problem. >> >> Using firefox, the

[web2py] Re: Login page - Menu bar does not work

2017-06-06 Thread Anthony
On Tuesday, June 6, 2017 at 4:13:26 PM UTC-4, Jordan Ladora wrote: > > I notice the same problem. > > Using firefox, the js console reveals that web2py-bootstrap3.js is trying > to call the function "web2py.validate_entropy", which is in web2py.js, but > cannot find it. >

[web2py] Re: How to access selected fields/objects in SQLFORM.grid as opposed to grid row ids

2017-06-06 Thread Peter
STOP PRESS! As has happened more than once - documenting the problem opened my mind to other possibilities. I was wrong in saying... "One post indicated this was a list of the task ids but not from what I can see, instead it appears to me to be returning the grid row ids for checked items."

[web2py] How to access selected fields/objects in SQLFORM.grid as opposed to grid row ids

2017-06-06 Thread Peter
Good morning all, I am using SQLFORM.grid for the first time and I'm baffled (not for the first time). Related posts don't illuminate my issue and at least one seems to contradict what I'm seeing. This is the controller - with some dross removed... tasks = (db.task.person == person.id)

[web2py] Re: how to query json field (with filter in/out) by equality

2017-06-06 Thread Anthony
Why have you defined custom filter_in and filter_out functions to convert to/from JSON -- that is handled automatically by the DAL when you specify the "json" field type? On Tuesday, June 6, 2017 at 8:54:27 PM UTC-4, Jurgis Pralgauskis wrote: > > Hi, > I use json field with following filters >

[web2py] Re: How to use Let's Encrypt with Web2Py on Apache

2017-06-06 Thread Raymond Smith
Dave That standalone flag saved my life !!! I LOVE YOU :D :D :D thankyou a ton !!! On Wednesday, May 31, 2017 at 7:43:09 AM UTC+12, Dave S wrote: > > > > On Tuesday, May 30, 2017 at 12:05:01 PM UTC-7, Dave S wrote: >> >> >> >> On Tuesday, May 30, 2017 at 8:50:50 AM UTC-7, Raymond Smith wrote:

[web2py] how to query json field (with filter in/out) by equality

2017-06-06 Thread Jurgis Pralgauskis
Hi, I use json field with following filters Field('responses', 'json'), db.learn.responses.filter_in = lambda obj, dumps=dumps: dumps(obj) db.learn.responses.filter_out = lambda txt, loads=loads: loads(txt) but if I want to select based on equality -- nothing is found -- query:

[web2py] How can javascript reads a SQLFORM field which writable=False

2017-06-06 Thread Rudy
I posted a question a couple days ago asking how I can read a SQLFORM's field and update it using javascript when its writable=False (because user is not supposed to make change to the subtotal field manually, it should be calculated based on the sum of all the items), but I didn't get any

Re: [web2py] Re: 'validate_and_insert' throws error each time on latest version where it was fine before on prev version

2017-06-06 Thread Jordan Ladora
Thank you for checking that. Yeah, I'm still getting this, even when logged in. As a temp workaround I swapped all the instances of "validate_and_insert" in my app for "insert". I did find a note I made a couple years ago from back before I upgraded to the latest version that said

[web2py] Re: Login page - Menu bar does not work

2017-06-06 Thread Jordan Ladora
I notice the same problem. Using firefox, the js console reveals that web2py-bootstrap3.js is trying to call the function "web2py.validate_entropy", which is in web2py.js, but cannot find it. The error is: * ReferenceError: web2py is not defined. * (line 14, posn 7 of web2py-bootstrap3.js).

[web2py] Re: "import ssl" impossible in Web2py with python 2.7.9 but "import ssl" working with python 2.7.9

2017-06-06 Thread e27gis
Funny thing : On the distant server, 1/ If I launch the mail controller from Web2py.exe (127.0.0.1/admin), it does find SSL module (python version 2.7.9) --> the mail is sent 2/ If I launch the mail controller as 'localhost/admin' i.e. through Apache 2.4, it does not find the SSL module

[web2py] Re: [web2py/web2py] Auth add_membership and del_membership mistakenly alter the logged-in user's session (#1638)

2017-06-06 Thread Anthony
> > When you mention "persist the list of flagged users", it mean that there > is no such thing as persistence in web2py and that at each request web2py > is completely "ignorant" about any given state it may find itself in?? > Well, each request is executed independently, though there are

[web2py] Re: "import ssl" impossible in Web2py with python 2.7.9 but "import ssl" working with python 2.7.9

2017-06-06 Thread Anthony
> Your SSL module is probably in your Python's site packages, and web2py may > not be looking there > (it has its own ideas about where packages should be). > No, web2py will find modules in the usual Python search path, though it will also find modules in the /modules folder of the current

Re: [web2py] Migration fails when dropping a column on Postgresql

2017-06-06 Thread Anthony
On Tuesday, June 6, 2017 at 2:36:19 AM UTC-4, Doug Taylor wrote: > > This is becoming a show-stopper for me now as I cannot ADD fields to an > exiting table either. > It shouldn't be a show stopper, as you can always migrate the database via other means. Just use an external tool, or simply run

[web2py] Re: "import ssl" impossible in Web2py with python 2.7.9 but "import ssl" working with python 2.7.9

2017-06-06 Thread Dave S
On Tuesday, June 6, 2017 at 3:32:22 AM UTC-7, e27...@gmail.com wrote: > > > I have sending email problems that I am sure are related to SSL/TLS. > > I am running the last Web2py version with Python 2.7.9 and Apache 2.4 > > When I make a mail script with SMTPLIB, Web2py tells me that SSL is not

[web2py] Re: Code editor with code completion

2017-06-06 Thread Dave S
On Tuesday, June 6, 2017 at 11:11:47 AM UTC-7, Ron Chatterjee wrote: > > wing IDE. > > And do you have an answer to his question about Wing IDE? > On Tuesday, June 6, 2017 at 9:34:01 AM UTC-4, Assela Pathirana wrote: >> >> Dear all, >> >> I have started dabbling with web2py since a few

Re: [web2py] auth.navbar modification

2017-06-06 Thread Richard Vézina
Hello Pierre, What are your trying to do exactly which doesn't work as expect?? The config you show us about login_next is not different from the default behavior of web2py so, I don't understand what you expect other than that... About registration_requires_verification and

[web2py] Re: possible error in autocomplete code

2017-06-06 Thread Anthony
Sorry, I forgot about that -- you can in fact use a virtual field. However, for it to work properly, you must specify the table name when defining the virtual field: db.auth_user.full_name = Field.Virtual('full_name', lambda row: '%s %s' %(row.auth_user.

[web2py] Re: Code editor with code completion

2017-06-06 Thread Ron Chatterjee
wing IDE. On Tuesday, June 6, 2017 at 9:34:01 AM UTC-4, Assela Pathirana wrote: > > Dear all, > > I have started dabbling with web2py since a few weeks. Created several > simple apps of my own and quite happy with it as a web framework. I have > the following questions, to which I could not

[web2py] Re: different default application based on the host header - Python anywhere - Go daddy

2017-06-06 Thread Ron Chatterjee
Seems working now. Sorry Massimo, may be I was getting the cache. On Monday, June 5, 2017 at 8:40:10 PM UTC-4, Ron Chatterjee wrote: > > Okay, but Massimo, > > What's the logic to route multiple domain to multiple different apps > hosted at pythonanywhere? The above don't seem to work

[web2py] Re: [web2py/web2py] Auth add_membership and del_membership mistakenly alter the logged-in user's session (#1638)

2017-06-06 Thread Richard Vézina
We could continue this conversation here... When you mention "persist the list of flagged users", it mean that there is no such thing as persistence in web2py and that at each request web2py is completely "ignorant" about any given state it may find itself in?? I guess using session as a

[web2py] Re: preserve search criteria in sqlform.grid after component reLOAD

2017-06-06 Thread Jonathan Tomm
Thanks, this save me a lot of trouble! -- 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

Re: [web2py] Migration fails when dropping a column on Postgresql

2017-06-06 Thread Richard Vézina
Just some thought not solution... Maybe you could try to decouple your data from your table, by doing so you then will be able to flush the entire model instead of just modify it (ALTER), that way you will avoid the issue with rname. You can use this trick to decouple your basic required data :

[web2py] Re: possible error in autocomplete code

2017-06-06 Thread Carlos Kitu
Thanks a lot, Anthony. I use to check the framework code before posting questions, and when I saw this in the callback method of the autocomplete widget: def callback(self): if self.keyword in self.request.vars: field = self.fields[0] if type(field) is Field.Virtual:

[web2py] Code editor with code completion

2017-06-06 Thread Assela Pathirana
Dear all, I have started dabbling with web2py since a few weeks. Created several simple apps of my own and quite happy with it as a web framework. I have the following questions, to which I could not find a satisfactory answer within the mailing list. I would be very much grateful if

[web2py] Re: web2py 2.15.1

2017-06-06 Thread Anthony
On Tuesday, June 6, 2017 at 5:02:10 AM UTC-4, tim.nyb...@conted.ox.ac.uk wrote: > > Re #3: I highly recommend swapping in Eonasdan's bootstrap-datetimepicker: > https://github.com/Eonasdan/bootstrap-datetimepicker > That's nice but is tied to Bootstrap and has a lot of dependencies. Something

[web2py] "import ssl" impossible in Web2py with python 2.7.9 but "import ssl" working with python 2.7.9

2017-06-06 Thread e27gis
I have sending email problems that I am sure are related to SSL/TLS. I am running the last Web2py version with Python 2.7.9 and Apache 2.4 When I make a mail script with SMTPLIB, Web2py tells me that SSL is not present. When I want to "import ssl" within a Web2py script, no ssl module is

[web2py] Re: grid add/edit form label

2017-06-06 Thread T.R.Rajkumar
Thanks a lot icodk. Now I am able to change the text of buttons. -- 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

[web2py] Re: web2py 2.15.1

2017-06-06 Thread tim . nyborg
Re #3: I highly recommend swapping in Eonasdan's bootstrap-datetimepicker: https://github.com/Eonasdan/bootstrap-datetimepicker I just altered my web2py_ajax.html to swap dependencies and initialize datepickers: # response.files.insert(1,'/inc/css/calendar.css') #

[web2py] Re: request.vars list object

2017-06-06 Thread 'Annet' via web2py-users
Hi Kiran and Anthony, Thanks for your replies. Indeed I have a form with field 'label' and a var 'label in the URL. Changing request.vars to request.get_vars solved the issue. Kind regards, Annet -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: grid add/edit form label

2017-06-06 Thread icodk
Sorry in your case it is form[1][0][2][0]="Som text" This will replace the text in the DOM element of the serialized form returned by the call to SQLFORM.smartgrid Please note that the indexes (1,0,2,0) I used above can be different in your case. To find out start by printing the element to the

Re: [web2py] Migration fails when dropping a column on Postgresql

2017-06-06 Thread Doug Taylor
This is becoming a show-stopper for me now as I cannot ADD fields to an exiting table either. I'm pretty sure adding fields worked before when I was running on Windows. Made the transition to Linux on my office desktop recently and that was when I first encountered the problem. Adding the

Re: [web2py] not authorised flash message when I used SQLFORM.grid, but worked fine with SQLFORM.smartgrid

2017-06-06 Thread Rudy
Right on Anthony, I don't think user_signature=False is the real fix for the strange behaviour. When i tested it, i did log in, plus i used smartgrid the same way. Thanks for confirming it. On Monday, June 5, 2017 at 9:14:48 PM UTC+8, Anthony wrote: > > On Monday, June 5, 2017 at 1:11:25 AM