[web2py] Re: How to prevent submitting form details that already exist as a record in the database

2020-07-19 Thread mostwanted
Thank you On Saturday, July 18, 2020 at 10:16:09 PM UTC+2, Dave S wrote: > > > > On Friday, July 17, 2020 at 2:38:43 AM UTC-7, mostwanted wrote: >> >> Hey Dave, thanks for replying, >> This below is what I tried & it seems to be working, idont know if the >> best solution but please help e where

[web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread mostwanted
In my application I have 4 tables, 3 of them referenced in the fourth table but every user should be able to view only what they have entered into the database. Is there a way that in a dropdown list of a referenced table in an SQLFORM users can only view & select from items they have entered?

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers
I would try using a common_filter on the drop down list table. Could that work? On Sun, 19 Jul 2020, 6:10 pm mostwanted, wrote: > In my application I have 4 tables, 3 of them referenced in the fourth > table but every user should be able to view only what they have entered > into the database. I

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread mostwanted
Hey AGRogers, thanks for that suggestion, I added the highlited lines to my model code & it gave results, thank you very much: db.define_table('lecturer', Field('surname'), Field('name'), Field('title'), Field('posted_by', 'referenc

[web2py] Search and filtering

2020-07-19 Thread Akshata Naduvinahalli
Consider that :you have list of names,which you have entered through front end and you have search and filter the entered data on the search box. Please send the video related or code for this. On Sun 19 Jul, 2020, 6:36 PM mostwanted, wrote: > Hey AGRogers, thanks for that suggestion, I added th

[web2py] Search and Filtering

2020-07-19 Thread Akshata Naduvinahalli
can anyone help me to code for searching and filtering for data entered in front end web page in web2py? -- 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) ---

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers
Great. It's a cool feature. You would have read that you can turn it off in code temporarily just by setting common_filter =none. That has caught me a few times. On Sun, 19 Jul 2020, 11:06 pm mostwanted, wrote: > Hey AGRogers, thanks for that suggestion, I added the highlited lines to > my mod

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread Sanka kanaka krupakar
Dear group members Please advise how to create multiple rows insert by usung SQL form . On Mon 20 Jul, 2020, 05:37 AGRogers, wrote: > Great. It's a cool feature. > > You would have read that you can turn it off in code temporarily just by > setting common_filter =none. > > That has caught me a

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers
I'm not sure that is possible Sanka. At least I have not read it in the book nor seen it referenced by anyone. I expect you have to write a custom form and handle it manually. But web2py can still help with those tasks. On Mon, 20 Jul 2020, 12:45 pm Sanka kanaka krupakar, wrote: > Dear group me

[web2py] Any alternative to installing web2py on laptop

2020-07-19 Thread Nishant Bansal
Hi, I have a company provided laptop and I cannot install any external software on it. Is there any way to being able to work using web2py without installing it, for e.g - there are online versions of Jupyter notebook available for writing python code. Thanks, Nishant -- Resources: - http://

[web2py] Re: 255

2020-07-19 Thread Ivan Luis
Where can i found pycache ? Em terça-feira, 26 de maio de 2020 04:41:45 UTC-3, Geo escreveu: > > I use python 3.7 but I had the same issue, to solve it I kind of cheated > by adding MySQL default charset 255 > > in gluon\contrib\pymsysql\charset.py I have added this at line 260 (at > the end of

Re: [web2py] Any alternative to installing web2py on laptop

2020-07-19 Thread AGRogers
Sure. pythonanywhere.com is where I started. Maybe it can run from a USB stick? I think it is pretty portable - but i have never done that and you would be better listening to someone else. On Mon, 20 Jul 2020 at 15:24, Nishant Bansal wrote: > Hi, > I have a company provided laptop and I cannot

Re: [web2py] Any alternative to installing web2py on laptop

2020-07-19 Thread Warwick JC
I also just use a local folder to run Web2py. You can still use the laptop by downloading the source file and unpacking it to a local folder. Regards On Mon, Jul 20, 2020, 08:32 AGRogers wrote: > Sure. pythonanywhere.com is where I started. > > Maybe it can run from a USB stick? I think it is pr