[web2py] admin table query focus

2024-04-23 Thread Dave S
c details are. Dave S /dps -- 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 Groups &qu

[web2py] Re: web2py website

2024-02-29 Thread Dave S
On Wednesday, February 21, 2024 at 11:29:07 AM UTC-8 syna...@gmail.com wrote: Will the web2py website be getting a refresh anytime? That award badge - it's from 14 years ago. web2py is in maintenance mode. Spiffing up the website isn't an important sales tool. Here's hoping py4web gets

[web2py] Re: 2.19.0 vs 2.27.1

2024-02-29 Thread Dave S
On Monday, February 12, 2024 at 8:12:05 AM UTC-8 gaelpri...@gmail.com wrote: Hello everybody. I've actually some instances of web2py running with the 2.19.0 version. 0 problems, thank you web2py. One of these is this one: https://www.hydrover.it/ It uses the web2py grid, Bootstrap 2.3.2. I

Re: [web2py] shell.py, unqualified exec is not allowed

2024-02-29 Thread Dave S
On Tuesday, February 6, 2024 at 11:40:00 AM UTC-8 apinho wrote: Hi, Thank you. I was under the impression that web2py was only compatible with Python2.7, and that py4web was for Python3x. I now understand that py2web has been modified and is also compatible with Python3, up to 3.11. That

[web2py] Re: reCAPTCHA link in online web2py book

2024-01-31 Thread Dave S
On Sunday, January 28, 2024 at 5:41:01 AM UTC-8 lucas wrote: anyone on this, at all? Sorry, I haven't used recaptcha, but I think there was a recent thread about it in the py4web forum. Good luck /dps On Monday, January 22, 2024 at 9:01:02 AM UTC-5 lucas wrote: hello one and all, the

[web2py] Re: Failing to download search results as csv

2024-01-15 Thread Dave S
On Tuesday, August 22, 2023 at 2:32:48 AM UTC-7 mostwanted wrote: Hi guys, i need help downloading results as csv, i am failing dismally I dont know what to do After the search results return values I want to download those results into my computer somewhere the current version of my code is

[web2py] stale session with FORM and its kin

2024-01-15 Thread Dave S
ssue, but it seems hokey to do that for all such forms. However, about the only other idea I've come up with is to use a timer to cause a "redirect" to self, thus doing a fresh GET of the form. Has anyone else come up with a better than either of those choices? Thanks for your thou

[web2py] Re: cibersecurity audit issue about login

2023-12-31 Thread Dave S
On Thursday, November 16, 2023 at 9:32:58 AM UTC-8 Ramos wrote: Hello friends, i guess this is a similar issue between web2py and py4web so im posting to both groups. Sorry if im abusing ... We had a cibersecurity audit in our web2py app and they found this issue QUOTE During the application

[web2py] Does SQLFORM support "onvalidation"?

2023-09-15 Thread Dave S
Short answer: YES I was having trouble with "onvalidation" ... the code didn't seem to be running. So I was going to ask if SQLFORM supported it ... but [blush] when preparing my question, I realized I had set the option on the wrong form. (I have a ping-pong pair of forms ... you enter

[web2py] Re: PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'D:\\Data\\XYZ\\applications\\MyApp\\private\\app.log'

2023-08-31 Thread Dave S
On Wednesday, August 23, 2023 at 9:55:49 PM UTC-7 david@gmail.com wrote: We have activated logging in our applications and have defined 2 back-ups for the rotation. We often get errors when running web2py shell scripts because I think that the the web2py web application and the web2py

[web2py] Re: Error with redis and web2py 2.24.1: Invalid input of type: 'NoneType'. Convert to a bytes, string, int or float first.

2023-05-09 Thread Dave S
On Monday, May 8, 2023 at 6:36:13 AM UTC-7 Lisandro wrote: Hey there! I recently updated to Web2py Version 2.24.1-stable+timestamp.2023.03.23.05.07.17 It uses python 3.9.14, running in production serving around 60 requests per second, using resources efficiently and running really smoothly

[web2py] Re: Exceptional oddity in query processing

2023-05-09 Thread Dave S
On Monday, May 8, 2023 at 4:33:42 AM UTC-7 Jim S wrote: I think you want r = (db.badlist.PostDate != None) without the db in front of it. -Jim Thank you, sir! That seems to have been the key. Dave S /dps On Saturday, May 6, 2023 at 6:04:39 PM UTC-5 snide...@gmail.com wrote: Added

[web2py] Re: Messy views in Chrome after crash

2023-05-07 Thread Dave S
On Saturday, May 6, 2023 at 4:33:08 PM UTC-7 Dave S wrote: Weird copy-paste error on the first paragraph, which should read: Every now and then, my older laptop says it can't handle umpteen dozen tabs any more, it's done swapping, and it nosedives into a blue screen. This laptop is also

[web2py] Re: Messy views in Chrome after crash

2023-05-06 Thread Dave S
server. Window 10+ environment. On Saturday, May 6, 2023 at 4:31:28 PM UTC-7 Dave S wrote: > Every now and then, my older laptop says it can't handle umpteen dozen > tabs any more, it's done swapping, and it nosedives into a blue screen. > This laptop is also hosting the dev versi

[web2py] Messy views in Chrome after crash

2023-05-06 Thread Dave S
sites. Thanks Dave S /dps -- 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 Groups

[web2py] Re: Exceptional oddity in query processing

2023-05-06 Thread Dave S
Added missing frame info On Saturday, May 6, 2023 at 3:51:43 PM UTC-7 Dave S wrote: Why does this - *File C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py in _select_aux at line 865* code arguments variables Function argument

[web2py] Exceptional oddity in query processing

2023-05-06 Thread Dave S
Why does this - *File C:\Users\Dave\web2py_src\web2py_src-2.22.5\web2py\gluon\packages\dal\pydal\adapters\base.py in _select_aux at line 865* code arguments variables Function argument list (self=, sql='SELECT "badlist"."id", "badl

[web2py] Re: Is it possible to change the boolean field widget from checkbox to option with yes and no?

2023-03-29 Thread Dave S
On Wednesday, March 29, 2023 at 4:46:26 AM UTC-7 Dave S wrote: On Wednesday, March 29, 2023 at 4:10:19 AM UTC-7 Dave S wrote: On Sunday, February 26, 2023 at 5:51:30 AM UTC-8 jeff...@gmail.com wrote: Is it possible to change the boolean field widget from checkbox to option with yes and no? How

[web2py] Re: Is it possible to change the boolean field widget from checkbox to option with yes and no?

2023-03-29 Thread Dave S
On Wednesday, March 29, 2023 at 4:10:19 AM UTC-7 Dave S wrote: On Sunday, February 26, 2023 at 5:51:30 AM UTC-8 jeff...@gmail.com wrote: Is it possible to change the boolean field widget from checkbox to option with yes and no? How? I don't think you can do that with the default radio widget

[web2py] Re: Is it possible to change the boolean field widget from checkbox to option with yes and no?

2023-03-29 Thread Dave S
On Sunday, February 26, 2023 at 5:51:30 AM UTC-8 jeff...@gmail.com wrote: Is it possible to change the boolean field widget from checkbox to option with yes and no? How? I don't think you can do that with the default radio widget. This works: form3 = SQLFORM.factory(

[web2py] Re: web2py with rocket server + nginx ?

2023-02-16 Thread Dave S
On Thursday, February 16, 2023 at 7:26:40 AM UTC-8 chriii...@gmail.com wrote: Hello! I'm wondering if it is a good idea to use web2py with rocket server in combination with nginx as a reverse proxy like in py4web. I need to run py4web and web2py on the same server and using nginx without

[web2py] Does web2py/PyDal support rowvalues?

2023-01-23 Thread Dave S
with it in the PyDal enviornment, but I don't think this is covered in the web2py book. Thanks. Dave /dps -- 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

[web2py] Re: where is the path specified that points to python.exe

2022-12-08 Thread Dave S
On Sunday, November 27, 2022 at 9:00:57 AM UTC-8 alexg...@gmail.com wrote: > I mean where in the Web2py source code or settings can I tell web2py > which instance of python to use. Where can I type the path? > One way of handling this is to use a command window with a specific %PATH%

[web2py] Re: Grid: case insensitive sort

2022-11-04 Thread Dave S
On Thursday, November 3, 2022 at 8:57:23 AM UTC-7 vincent...@gmail.com wrote: > Hello, > > I have a simple SQLFORM.grid that shows the rows of my simple SQLite > database. > In the grid, when I click on, say, the "vendorname" column header, this > performs a kind of alphabetical sort, but the

[web2py] Re: DAL: basic join question

2022-10-27 Thread Dave S
ery, from before I tried a simplified problem. Now that you've helped my through the simplified problem, I can go back and see how far I get in the deeper mud. If that doesn't work, can you share you're whole model? Seems like the > picnotes def is off a bit. > > -Jim > Dav

[web2py] Re: Server Deployement issue

2022-10-26 Thread Dave S
On Tuesday, October 25, 2022 at 10:57:55 PM UTC-7 silvia...@gmail.com wrote: > Hey snide, > > do you mind helping me setting it up in an ngnix enviromenet I would also > pay you somthing for your time > > Pay sounds good to me, but I'm not sure you'd get your money's worth. It's been a while

[web2py] DAL: basic join question

2022-10-26 Thread Dave S
ll rows of pics that have a note referring to them (this is a simplified version of what I really want). I'm trying to follow the book, and double-checking with posts in this group (and peeking at the p4web group), but I keep getting the error near "<": syntax error where the traceback go

[web2py] Re: File Upload there is a little text I want to hide

2022-10-25 Thread Dave S
On Tuesday, October 25, 2022 at 12:38:37 AM UTC-7 silvia...@gmail.com wrote: > > Thanks anyway figured it out was a line of code in the controller I love success stories! /dps > snide...@gmail.com schrieb am Freitag, 21. Oktober 2022 um 23:05:32 UTC+7: > >> On Thursday, October 20, 2022 at

[web2py] Re: About images in mail.sent

2022-10-21 Thread Dave S
On Friday, October 21, 2022 at 8:59:43 AM UTC-7 Ramos wrote: > Coding like in the manual > > mail.send('y...@example.com', > 'Message subject', > '', > attachments = mail.Attachment('/path/to/photo.jpg', content_id='photo')) > > > > all the images appear at the bottom of the email as

[web2py] Re: File Upload there is a little text I want to hide

2022-10-21 Thread Dave S
On Thursday, October 20, 2022 at 2:16:42 AM UTC-7 silvia...@gmail.com wrote: > Hello everyone , > > I implemented a file upload in web2py and there is a little text in a span > that is annoying but I can not just hide all the spans on my page any > suggestions see screenshot > I think we

[web2py] Re: Server Deployement issue

2022-10-11 Thread Dave S
On Wednesday, October 5, 2022 at 9:23:07 PM UTC-7 silvia...@gmail.com wrote: > I forgot to add that I want to deployment my web2py on a local network to > run it as an Intranet. > > That shouldn't be an issue. But I can only offer limited help on whatever *is* the issue because I use the

[web2py] Re: Silly Question about invalid controller/function

2022-10-03 Thread Dave S
On Monday, October 3, 2022 at 5:21:52 PM UTC-7 Dave S wrote: > On Monday, October 3, 2022 at 5:14:23 PM UTC-7 Dave S wrote: > >> If I mistype the funtion or controller name, the response displayed is >> "invalid function (controller/wrongfunc) " or "invalid c

[web2py] Re: Silly Question about invalid controller/function

2022-10-03 Thread Dave S
On Monday, October 3, 2022 at 5:14:23 PM UTC-7 Dave S wrote: > If I mistype the funtion or controller name, the response displayed is > "invalid function (controller/wrongfunc) " or "invalid controller > (wrongctlr/function)". These have status 404, but don't dis

[web2py] Silly Question about invalid controller/function

2022-10-03 Thread Dave S
If I mistype the funtion or controller name, the response displayed is "invalid function (controller/wrongfunc) " or "invalid controller (wrongctlr/function)". These have status 404, but don't display "404" in the body. I think it would make the error message better if it was "404: invalid

[web2py] Re: Custom Login Decorator

2022-09-30 Thread Dave S
On Saturday, September 24, 2022 at 1:43:13 AM UTC-7 mostwanted wrote: > So I was able to figure my problem out thanks to Arglanir. I put in > alittle effort & I achieved positive results with the code below. > > def onetimecode(func): > def wrapper(): > details=['not logged',

[web2py] Re: Bypass web2py for static maintenance page

2022-09-30 Thread Dave S
On Wednesday, September 21, 2022 at 2:26:47 PM UTC-7 scot...@gmail.com wrote: > I found the answer to my own question. So in case anyone else finds it > useful: > > Instead of using the WSGIScriptAlias directive you can use > WSGIScriptAliasMatch which allows for regular expressions. Then I

[web2py] appadmin table view

2022-09-16 Thread Dave S
It's rather annoying waiting for appadmin to produce a drop down list with 1 entries. /dps -- 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

[web2py] Re: quick form styling question

2022-09-07 Thread Dave S
; snide...@gmail.com schrieb am Dienstag, 6. September 2022 um 13:12:32 > UTC+7: > >> On Saturday, September 3, 2022 at 5:19:42 PM UTC-7 Dave S wrote: >> >>> Warning: everything I know about BootStrap (BS4) I've learned from the >>> examples, so I Don't Kn

[web2py] Re: I have two form submit buttons but I only want one is it possible to hide the other one ?

2022-09-06 Thread Dave S
On Sunday, September 4, 2022 at 8:00:25 PM UTC-7 silvia...@gmail.com wrote: > Hello everyone, I think I have an issue that can not be resolved that easy > to be quite honest I have a custom form and an post form on the same page > my issue is I think I made a mistake with the design since it

[web2py] Re: quick form styling question

2022-09-06 Thread Dave S
On Saturday, September 3, 2022 at 5:19:42 PM UTC-7 Dave S wrote: > Warning: everything I know about BootStrap (BS4) I've learned from the > examples, so I Don't Know Much. > > Slightly related question: what is the best widget for a factory form field using IS_IN_SET[ .. sev

[web2py] Re: quick form styling question

2022-09-06 Thread Dave S
;form-vertical", but that didn't work ... I was adding a class, not >> replacing a class. >> >> (And beside,s that raises the question, what are those two classes really >> doing?) >> >> Thanks for any advice, >> >> Dave S >> /dps >>

[web2py] quick form styling question

2022-09-03 Thread Dave S
, not replacing a class. (And beside,s that raises the question, what are those two classes really doing?) Thanks for any advice, Dave S /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

[web2py] Re: Change Form Redirect URL depending on selection

2022-09-03 Thread Dave S
On Monday, August 29, 2022 at 3:20:22 AM UTC-7 silvia...@gmail.com wrote: > That would be my controller function I know it is totally wrong but dont > know what tu put in there to be honest > > > def add(): > form = SQLFORM(db.projects, _name='form_add') > > if country in

[web2py] Re: Web2py deployment on a local so all computers in the network can acess it

2022-09-03 Thread Dave S
On Monday, August 29, 2022 at 3:13:02 AM UTC-7 silvia...@gmail.com wrote: > I will run it on a virtual server I think > Sounds like a good choice. Many virtual server providers make provisioning easy. /dps > > snide...@gmail.com schrieb am Montag, 29. August 2022 um 15:14:58 UTC+7: > >>

[web2py] Re: Change Form Redirect URL depending on selection

2022-08-29 Thread Dave S
On Sunday, August 28, 2022 at 7:50:27 PM UTC-7 silvia...@gmail.com wrote: > Actually I have 3 endpoints tier 1 tier 2 and tier 3 so example if > choosing Germany it should redirect to www.website/tier1.com if choosing > for example Viertnam it should redirect to www.website/tier3.com that is

[web2py] Re: Web2py deployment on a local so all computers in the network can acess it

2022-08-29 Thread Dave S
On Wednesday, August 24, 2022 at 7:59:43 PM UTC-7 silvia...@gmail.com wrote: > Thanks Tom I will try that > > Tom Clerckx schrieb am Mittwoch, 24. August 2022 um 16:53:30 UTC+7: > >> Not sure what information you're looking for. >> There is no dependency on having an internet connection to

[web2py] Re: Bug in gluon/scheduler.py

2022-08-21 Thread Dave S
On Saturday, August 20, 2022 at 11:39:55 AM UTC-7 Tom Clerckx wrote: > Our tasks are added using scheduler.queue_task(...) function. > > By default, we set the period to 0 > Why? If you don't know the period, why are you queuing it? Or are you using the "cron" type of task scheduling?

[web2py] Re: Bug in gluon/scheduler.py

2022-08-19 Thread Dave S
On Monday, August 8, 2022 at 3:50:26 AM UTC-7 Tom Clerckx wrote: > Version: > Version 2.22.5-stable+timestamp.2022.06.04.18.13.51 > > There is a problem with the calculation of next_run_time in > gluon/scheduler.py at line 1024 > > It calculates: > steps = secondspassed // task.period + 1 > >

[web2py] Next 100 broken in appadmin queries?

2022-08-19 Thread Dave S
dmin/select/db?start=100 Query on the previous page (the start=0 page): "db.QuarterMaster.id>0" This seems pretty serious to me. Dave S /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.goo

[web2py] Re: retrieving GET request (parameters; @service.json)

2022-08-06 Thread Dave S
On Friday, August 5, 2022 at 6:52:00 PM UTC-7 Dave S wrote: > On Wednesday, August 3, 2022 at 12:27:11 PM UTC-7 Vlad wrote: > >> If the following is exposed: >> >> @service.json >> def test(a, b): >> >> >> it works just fine when I

[web2py] Re: retrieving GET request (parameters; @service.json)

2022-08-05 Thread Dave S
On Wednesday, August 3, 2022 at 12:27:11 PM UTC-7 Vlad wrote: > If the following is exposed: > > @service.json > def test(a, b): > > > it works just fine when I submit url?a=val1;b=val2 > > but when I submit a dictionary - {"a":"val1", "b":val2"} - I can't figure > out how to catch the

[web2py] Re: Send code to sms # for 2 factor auth

2022-08-05 Thread Dave S
On Tuesday, July 19, 2022 at 2:34:44 PM UTC-7 Jim S wrote: > For those who care, this was super-simple to implement once I took the > time to read the manual. I implemented using RingCentral as a transport to > send sms messages. > > -Jim > I love a self-help success story! Congratulations!

[web2py] download uploaded files bump in the road

2022-07-13 Thread Dave S
The upload files feature in the DAL encodes the original name in base64 and adds that to the unique portion of the filename on the server. Bad news if you want to download one of those files and the base64 '=' character appears in the filename., because the browser thinks you doing an illegal

Re: [web2py] Re: sessions folder under application

2022-07-13 Thread Dave S
On Thursday, July 7, 2022 at 1:07:02 AM UTC-7 Niphlod wrote: > there's an handy session cleaner web2py/sessions2trash.py at master · > web2py/web2py (github.com) > and > a whole section in the docs web2py -

[web2py] melding css and w2p locals

2022-06-15 Thread Dave S
know the viewport size (doesn't seem to be a subfield of the request var), and I don't know another CSS-side value for the viewport height than the vh units. Thanks Dave S /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: App crushed during a web2py upgrade

2022-06-13 Thread Dave S
, reload > import gluon.rewrite > Hmmm, I can find that function in the 2.22.3 version, so It's still around. It will take someone with a more intimate understanding of the subsystem to explain the problem. I do use a load() call in my apps, but the one I use the most loads a for

[web2py] Re: App crushed during a web2py upgrade

2022-06-11 Thread Dave S
On Saturday, June 11, 2022 at 1:11:03 AM UTC-7 mostwanted wrote: > I was able to resolve the problem, I reloaded the app from my > pythonanywhere account and i was able to access my admin but i still can > not get my callback to work as expected. Can someone please help me! What > am i doing

Re: [web2py] Re: Pillow not imported by web2py-win

2022-05-13 Thread Dave S
On Monday, May 9, 2022 at 5:19:42 PM UTC-7 Dave S wrote: > On Sunday, May 8, 2022 at 1:55:52 AM UTC-7 nico...@gmail.com wrote: > >> Hi Dave, >> >> the simplest solution is surely to use web2py from source - and it's even >> better on py3 if possible. >> &g

[web2py] Re: simple error on QLFORM.factory

2022-05-12 Thread Dave S
On Thursday, May 12, 2022 at 4:05:34 PM UTC-7 Dave S wrote: > On Thursday, May 12, 2022 at 8:26:17 AM UTC-7 Ramos wrote: > >> Hello >> Just trying to teach someone some web2py stuff from the web2py book and i >> got stuck at the beginning. >> My friend computer r

[web2py] Re: simple error on QLFORM.factory

2022-05-12 Thread Dave S
On Thursday, May 12, 2022 at 8:26:17 AM UTC-7 Ramos wrote: > Hello > Just trying to teach someone some web2py stuff from the web2py book and i > got stuck at the beginning. > My friend computer returns this error. > The same code in my pc is ok > def first(): > form =

[web2py] Re: Pillow not imported by web2py-win

2022-05-12 Thread Dave S
On Friday, May 6, 2022 at 11:00:42 PM UTC-7 Massimo Di Pierro wrote: > can you try "pip install pillow" instead of putting it in > C:\Users\Dave\web2py_win\web2py_win_2.21.1_py27\web2py\site-packages > Not all packages like to be there and it can create problems. > >

Re: [web2py] Re: Pillow not imported by web2py-win

2022-05-09 Thread Dave S
On Sunday, May 8, 2022 at 1:55:52 AM UTC-7 nico...@gmail.com wrote: > Hi Dave, > > the simplest solution is surely to use web2py from source - and it's even > better on py3 if possible. > > If you're stick with the frozen app (apart from my simple guide on this at &g

[web2py] Pillow not imported by web2py-win

2022-04-20 Thread Dave S
that needed to use the package did from PIL import Image which resulted in the stacktrace: Traceback (most recent call last): File "C:\Users\Dave\web2py_win\web2py_win_2.21.1_py27\web2py\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:/Users/

[web2py] Re: Best way to have form submit disabled until file selected

2022-04-11 Thread Dave S
On Sunday, April 10, 2022 at 3:10:27 PM UTC-7 Ramos wrote: > Hello i have a form with a file to upload. > What is the best web2py way to have the submit button disabled until the > user selects a file to upload? > Regards > António > I'd say javascript, since the "required" validator only

[web2py] SQLTABLE and glosses

2022-04-06 Thread Dave S
I want to add a feature to a page where I'm using SQLTABLE to display some of the columns of a db table. I want to add tooltips to some of the columns I'm displaying. and I want to create those tooltips from columns I'm not displaying. Is there a way to do that still using SQLTABLE, or do I

[web2py] Re: Strange behavior slows server down

2022-04-06 Thread Dave S
on the bottom for "2 new posts . read?" This can hours later. /dps "yeah, I'm griping" On Friday, April 1, 2022 at 3:17:14 PM UTC-7 Dave S wrote: > So far, I'm not seeing the problem with Opera as the local client, or > Chome across the network, but I haven't st

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-04-03 Thread Dave S
On Friday, March 25, 2022 at 11:14:07 PM UTC-7 Rahul wrote: > yes I used some things like *trunc *or *ceil *to fix it however the error > persists on the same line. Pretty weird. Also used what was suggested like > // > but did not work for me. I want to get this fixed soon. However, > If

[web2py] Re: db.define_table("login", Field("_First Name:",requires = IS_NOT_EMPTY()), Field("_Other Names:",requires = IS_NOT_EMPTY()), Field("Profile:", "text") Field("image" ,"upload",),

2022-04-03 Thread Dave S
On Friday, April 1, 2022 at 11:29:19 PM UTC-7 igboji...@gmail.com wrote: > this code is not working in the data base model What does "not working" mean? What fails? What are you expecting? /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Strange behavior slows server down

2022-04-01 Thread Dave S
22000.556 and Chrome 99.0.4844.84 (64-bit). /dps On Wednesday, March 30, 2022 at 2:53:15 AM UTC-7 Dave S wrote: > Recently, I've been seeing one of my test web2py servers get bogged down, > and sometimes fail to respond to the user. When this happens, I find the > web2py.log file is getti

[web2py] For joins, matching on a list field element.

2022-03-31 Thread Dave S
ather than a manual iteration (or nested selects), where the stuff.durations contains a match for some nonsense.timing or where the stuff.tones contains a match for some nonsense.norm, how do I write that? Thanks. Dave S /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentati

Re: [web2py] Exporting html table as csv

2022-03-31 Thread Dave S
On Wednesday, March 30, 2022 at 8:37:29 AM UTC-7 mostwanted wrote: > Its a permanent html table in the view with information from different > database tables. From there i wanna download it as CSV to be used in excel > reports. > "Permanent html table" does make sense to me. Permanent means

[web2py] Strange behavior slows server down

2022-03-30 Thread Dave S
Recently, I've been seeing one of my test web2py servers get bogged down, and sometimes fail to respond to the user. When this happens, I find the web2py.log file is getting filled with lines like 2022-03-29 17:38:31,480 - web2py.scheduler.Dave-PC#8844 - DEBUG - defining tables (migrate=True)

Re: [web2py] Exporting html table as csv

2022-03-30 Thread Dave S
On Saturday, March 26, 2022 at 2:24:06 AM UTC-7 mostwanted wrote: > Thanks alot Murat, gratitude > Was http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#CSV-one-Table-at-a-time-> of any help? Are you creating a temporary table that you render the HTML from? > >

Re: [web2py] Re: Do we have Plugin solid form upgraded code for python 3 ?

2022-03-24 Thread Dave S
On Thursday, March 24, 2022 at 3:21:01 AM UTC-7 Massimiliano wrote: > This could be one problem: > > for i in range((max_row_lines - extra_colspan) / colspan): > > there are many of this. > > *range* take an integer, but a division in python3 return a float... > > Interesting, but why doesn't

[web2py] Re: About migrate and fake_migrate

2022-03-16 Thread Dave S
On Wednesday, March 16, 2022 at 1:56:33 AM UTC-7 Tom Clerckx wrote: > I was a bit confused about the explanation of the fake_migrate option in > the web2py documentation. After some experimenting, I wrote up the > following information for myself, just sharing it here with you. Maybe > someone

[web2py] Re: web2py.com down

2022-01-31 Thread Dave S
On Monday, January 31, 2022 at 1:03:28 PM UTC-8 Vlad wrote: > Indeed. > > On Sunday, January 30, 2022 at 10:20:06 PM UTC-6 Raul Monares wrote: > >> The site is down :( > > Continuing: GET http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer 500 (Internal Server Error)

[web2py] Re: more fun with SQLTABLE

2022-01-15 Thread Dave S
On Friday, January 14, 2022 at 11:56:57 PM UTC-8 Dave S wrote: > I'm working on Yet Another Personal Application, and in the main table I > define a field as type 'upload'. The upload works fine, and I can grab the > file back by the download function. But when I make a list o

[web2py] more fun with SQLTABLE

2022-01-14 Thread Dave S
to correct? Dave S /dps -- 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 Groups

Re: [web2py] (PWA) Send a Subscription information to my Server

2022-01-06 Thread Dave S
On Tuesday, January 4, 2022 at 1:44:36 AM UTC-8 mostwanted wrote: > I tried adding this to my code > > > > > > > *$.ajax({ type: "POST", url: > "https://www.sesoa.co.bw/init/default/func.html > ", data: >

[web2py] Re: Estore Error with stripe

2022-01-03 Thread Dave S
On Sunday, January 2, 2022 at 1:55:56 AM UTC-8 mauri...@gmail.com wrote: > Hello I got this error when trying out the Estore app. > File "/home/maurice/web2py/applications/EStore/controllers/default.py" > , > line > 157,

[web2py] Re: SQLTABLE columns in 2.21.1

2022-01-03 Thread Dave S
On Monday, December 20, 2021 at 8:18:43 PM UTC-8 Dave S wrote: > The code in sqlhtml.py for SQLTABLE has changed along the way from 2.18.5 > to 2.21.1, especially in the way it handles columns. > > Well, actually from 2.14.6, as I appeared to not have run this app in 2.18.5.

[web2py] Re: DataTable() not a function

2021-12-23 Thread Dave S
onday, December 20, 2021 at 10:01:32 PM UTC-6 snide...@gmail.com > wrote: > >> Jim? Other datatable gurus? >> >> /dps >> >> >> On Thursday, December 2, 2021 at 4:30:20 AM UTC-8 Dave S wrote: >> >>> That's the error I'm getting, according to

Re: [web2py] Re: Error ticket for "admin" when trying to create a view

2021-12-20 Thread Dave S
s? Also, in the ticket you may be able to see which of request.vars.sender and anchor is the null value. Dave S /dps > On Friday, December 17, 2021 at 2:52:22 PM UTC+2 Jim S wrote: > >> Is it possible your were no longer logged in or that you cleared your >> browser cache bef

[web2py] SQLTABLE columns in 2.21.1

2021-12-20 Thread Dave S
back (most recent call last): File "C:\Users\Dave\web2py_win\web2py_win_2.21.1_py27\web2py\gluon\restricted.py", line 219, in restricted exec(ccode, environment) File "C:\Users\Dave\web2py_win\web2py_win_2.21.1_py27\web2py\applications\QuarterMaster\views\default/sortedQ.html&

[web2py] Re: DataTable() not a function

2021-12-20 Thread Dave S
Jim? Other datatable gurus? /dps On Thursday, December 2, 2021 at 4:30:20 AM UTC-8 Dave S wrote: > That's the error I'm getting, according to Chrome's console. > > The view code is pretty simple: > > > var table; > $(document).ready(function(){ >table = $('#t

[web2py] Re: Learning Management System (LMS)

2021-12-13 Thread Dave S
On Wednesday, December 8, 2021 at 3:14:17 PM UTC-8 黄祥 wrote: > is there any web2py app or example to create Learning Management System > (LMS) with the exam ? > > thanks and best regards, > stifan > What is a Learning Management System? As for exams, I didn't find anything at web2pyslices,

[web2py] Re: video app

2021-12-08 Thread Dave S
server, which seems fairly straightforward. The other part would be receiving notifications. See this answer from 2016: https://groups.google.com/g/web2py/c/_87LHOJFMR0/m/7ONiuUwABwAJ > I suspect that this is even easier in py4web, though I'm way behind on studying that. Dave S /dps --

[web2py] Re: DataTable() not a function

2021-12-02 Thread Dave S
On Thursday, December 2, 2021 at 4:30:20 AM UTC-8 Dave S wrote: > That's the error I'm getting, according to Chrome's console. > > Do I have a conflict between dot-js files? > The view code is pretty simple: > > > var table; > $(document).ready(function(){ >

[web2py] DataTable() not a function

2021-12-02 Thread Dave S
That's the error I'm getting, according to Chrome's console. The view code is pretty simple: var table; $(document).ready(function(){ table = $('#tableXactions').DataTable( { "data": {{=results}} , "columns": [ /* { data: 'xaction.PostDate'}, */

[web2py] Re: import

2021-12-02 Thread Dave S
On Wednesday, November 17, 2021 at 1:30:31 PM UTC-8 lucas wrote: > hello one and all, > > this is not a web2py question or issue. but, since many are python > experts, i thought i'd ask. > > are there any other ways to import a module or package other then the > "import" or "from...import..."

[web2py] Re: Twinning tables in DAL

2021-12-02 Thread Dave S
On Monday, October 4, 2021 at 5:29:05 AM UTC-7 Anthony wrote: > See > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Table-inheritance > . > > Thank you. /dps > On Saturday, October 2, 2021 at 6:21:42 PM UTC-4 snide...@gmail.com wrote: > >> I need a reminder:

[web2py] Twinning tables in DAL

2021-10-02 Thread Dave S
I need a reminder: If I want a given table structure to be used in multiple tables (different instances existing at the same time), how do I set up my model? For small tables (lines of def) and a small number of tables, I can do a block copy, but is there a more, um, dynamic way to do this?

[web2py] Re: update_or_insert on an existing record returns None

2021-10-02 Thread Dave S
On Friday, September 24, 2021 at 2:18:44 AM UTC-7 Ramos wrote: > Why update_or_insert on an existing record returns None ?? > If the record does not exist it returns the created record id but if > updating an existing record i get None. > > Regards > António > Possibly so you can tell it was

[web2py] Re: Web2py site ssl expired

2021-09-22 Thread Dave S
On Wednesday, September 15, 2021 at 2:39:19 AM UTC-7 dirman wrote: > > Well same from my end. SSL expired > On Saturday, September 11, 2021 at 2:04:38 PM UTC+1 rodrig...@gmail.com > wrote: > >> Hello my friends, I don't know for report this. >> https://web2py.com/ when I access this url. >>

Re: [web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-09-02 Thread Dave S
Good to hear from you again! Keeping busy? /dps On Thursday, September 2, 2021 at 12:34:56 AM UTC-7 Niphlod wrote: > the timeout is part of rocket webserver, not web2py. if you're running > fastcgi, that's where you want to set a timeout: as configuration in IIS > (see python - How do I

[web2py] How to do hidden fields with SQLFORM.factory?

2021-09-02 Thread Dave S
I have a factory-built form that I've been happily using for a while, but now I want to add a field that is hidden unless a boolean in that form has been checked. The right thing for database table form is in the book:

[web2py] Re: How to add command line arguments to web2py when it is running as an application pool on IIS?

2021-08-30 Thread Dave S
On Thursday, August 26, 2021 at 11:30:34 PM UTC-7 david@gmail.com wrote: > Hi web2py folks, > > I would like to add a command line argument to the startup of web2py which > is running on an IIS web server. Can someone tell me the place where I > need to add those parameters on the IIS? >

[web2py] Re: Internal Server Error 500 when doing medium to heavy data processing

2021-08-29 Thread Dave S
On Thursday, August 26, 2021 at 4:34:43 AM UTC-7 david@gmail.com wrote: > Version > > 2.18.5-stable+timestamp.2019.04.08.04.22.03 > (Running on Microsoft-IIS/10.0, Python 3.6.8) > > Hello, > > We have been using web2py for a couple of years with very few issues, but > lately we have been

[web2py] Re: DAL Select(fields) puzzle

2021-08-25 Thread Dave S
On Wednesday, August 25, 2021 at 3:39:34 PM UTC-7 Rob Paire wrote: > Hi Web2py > I hope someone can explains this puzzling behavior. The code below was > taken from the book, and it works as given, but when I remove the > "yes_or_no" condition from the field list parameters it causes > a

[web2py] Re: How to encrypt password

2021-07-30 Thread Dave S
On Friday, July 30, 2021 at 1:34:44 PM UTC-7 isi_jca wrote: > Hi everybody: > > I was able to solve my problem. > >> >> Good to hear! /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

  1   2   3   4   5   6   7   8   9   10   >