[web2py] Object not found

I have 3 table, Items, Client & Purchases, the Client table stores the details of the customer, the items table has a list of sold items and Purchases stores what the customer purchased on what day. I have a function in the controller that allows the editing of Customer and Purchases details in

Re: [web2py] Broken/Changed Link on Web2py.com

Thank you Nico. Merged. On Thursday, 27 September 2018 12:25:46 UTC-7, Nico Zanferrari wrote: > > Hi, > > thaks for reporting. I've just made the PR2026 > "Python 3 compatibility + > fixed link for cookbook" in order to correct the web2py's home page,

[web2py] Re: Postgres migration errors

Congratulations! On Monday, 17 September 2018 23:39:50 UTC-7, Rahul wrote: > > Hi Everyone, > I am glad to say that my application ( > http://www.targetsoft.co.in/ ) is up and running on personal VPS. I've > added links to total of three applications all written in web2py > > 1. HMS (

[web2py] Re: How can i select an item from the database only once?

Thank you Dave but this URL https://web2py.com/boobs/default/29/07/forms-and-validators#SQLFORM-and-insert-update-delete

[web2py] Re: IMPORTANT - WEB2PY CONSULTING

Dear Massimo, I would to mention we-guide.com as consulting website for web2py. web2py powered site: https://ohta.ninja Thanks, Prakash On Monday, February 16, 2015 at 7:21:36 AM UTC+9, Massimo Di Pierro wrote: > > We need to update the list of companies that provide web2py consulting. > This li

[web2py] Openface/ OpenCV API Integration in Web2py

Hello Everyone, Please I will warmly appreciate any guidelines and instructions I can get from you, concerning how I can Integrate Openface or OpenCV APIs in my web2py website. Thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] getting insert error on modified_by field in auth_user with auth.register()

Dear developers, I'm using auth.register() to sign users up to a website but I am getting an error on the modified_by field in the auth_user table. modified_by isn't included in auth.register() and I can't pre populate the field. *Controller:* def user(): form = auth() form.vars.modi

[web2py] Connect DAL to Azure Postgres Instance

Trying to connect to Azure-hosted postgres on version 2.17.1-stable+timestamp.2018.08.06.01.02.56 If I try and connect with: db = DAL( "postgres://dbname@dbname-postgres:p...@dbname-postgres.postgres.database.azure.com/dbname" ) I get this: Invalid URI string in DAL I thought it might have to

[web2py] Re: How to capture auth_user login time & logout time

Thank you guys On Thursday, September 27, 2018 at 6:18:57 PM UTC+2, Joe Barnhart wrote: > > What Anthony said. Only sessions rarely log out. They mostly time out, > which does not show up as an event. > > Joe > > On Wednesday, September 26, 2018 at 12:13:25 PM UTC-7, mostwanted wrote: >> >> Hi

[web2py] Re: Limits of storing session in browser cookie?

Ah. Thanks for that. I don't have full control over what goes into session. I was suspicious because something which worked normally did not work when I was impersonating a user. I did notice the rather large amount of info stored in the session while impersonating, which got me wondering.

[web2py] Re: Autocomplete widget filter values

On Thursday, September 27, 2018 at 2:07:31 AM UTC-4, Armando Hernandez wrote: > > How can i filter tha value of the autocomplete values of a > SQLFORM.widgets.autocomplete(request,db.person.name) > > Lets say you only want the autocomplete widget to display person names of > persons with ages

[web2py] Re: Limits of storing session in browser cookie?

You'll be limited to 4KB (post-encryption). I suppose a reasonable alternative would be to use sessionStorage or localStorage in the browser. Also, there is a bug if using cookie sessions with AuthAPI (as opposed to Auth) -- on logout, if the session is empty (i.e., nothing left after auth.user

[web2py] Re: Setting writable and readable=True on all fields

db.mytable.fields (or .fields(), or ._fields) returns a list of field *names*. You can instead iterate over the table itself to get the field *objects*: for f in my_table: f.writable=f.readable=True Anthony On Thursday, September 27, 2018 at 6:01:13 PM UTC-4, icodk wrote: > > At a certain p

Re: [web2py] Setting writable and readable=True on all fields

Yep. I'm pretty sure 'fields' is a list so it doesn't need function parentheses. And since "my_table" and "db['my_table']" are the same: for f in my_table.fields: my_table[f].writable=True Same thing, but sweetened with syntactic sugar. (low calorie) -- Joe On Thursday, September 27,

Re: [web2py] Setting writable and readable=True on all fields

You need use the follow code: for f in my_table.fields(): db['my_table'][f].writable=True El jue., 27 de sep. de 2018 a la(s) 19:01, icodk (i...@alpiron.com) escribió: > At a certain point, I need to allow read and write on all fields of a > specific table > > How can I iterate through all

[web2py] Setting writable and readable=True on all fields

At a certain point, I need to allow read and write on all fields of a specific table How can I iterate through all fields in a table and set the writable, readable =true This does not work: for f in my_table.fields(): f.writable=f.readable=True -- Resources: - http://web2py.com - http://

[web2py] Re: lose focus events in form fields

There is some example script here which may help with the idea - both a setup for countries and subdivisions with Ajax and also a couple of range controls for urgency and importance where I then backfill the values into form fields for the actual values. As far as I am aware web2py does not ha

Re: [web2py] Broken/Changed Link on Web2py.com

Hi, thaks for reporting. I've just made the PR2026 "Python 3 compatibility + fixed link for cookbook" in order to correct the web2py's home page, and also to remark Python 3 compatibility. Nico Il giorno gio 27 set 2018 alle ore 00:15 Paul Ellis ha s

[web2py] Re: lose focus events in form fields

On Thursday, September 27, 2018 at 5:28:50 AM UTC-7, Rahul wrote: > > Hey All, > This is essential - I can do what Donald has said but I want to > do it at runtime. > Why would you not consider jQuery to be "at runtime"? He mentioned it in the context of setting the focus events, but

[web2py] Re: lose focus events in form fields

On Thursday, September 27, 2018 at 5:28:50 AM UTC-7, Rahul wrote: > > Hey All, > This is essential - I can do what Donald has said but I want to > do it at runtime. It would also be helpful when I try to implement say for > example select a country from drop down and then populate stat

[web2py] Re: How to capture auth_user login time & logout time

What Anthony said. Only sessions rarely log out. They mostly time out, which does not show up as an event. Joe On Wednesday, September 26, 2018 at 12:13:25 PM UTC-7, mostwanted wrote: > > Hi guys, i was wondering if there is a way for me to capture user login > time and user logout time > > R

[web2py] Limits of storing session in browser cookie?

I love the new(?) capability of storing the session information in a browser cookie. Mainly because I'm lazy and don't want the responsibility of determining when to throw out sessions and manage them on my end. I added this to my app: session.connect(request, response, cookie_key="mylittlepo

[web2py] Re: lose focus events in form fields

Hey All, This is essential - I can do what Donald has said but I want to do it at runtime. It would also be helpful when I try to implement say for example select a country from drop down and then populate states as per the country selected in another dropdown. may more use cases like t