[web2py] Re: I want to delete the file created as a result of an upload field.

2019-10-09 Thread Dave S
I don't understand the problem. Your table should have the server-side file name in the upload field (the_file), and I think you've seen that. Try doing a select() to get the value. That of course returns a row, so use row("the_file") with square brackets. That might save your short cut ver

[web2py] Re: I want to delete the file created as a result of an upload field.

2019-10-09 Thread 'jim kaubisch' via web2py-users
I agree in principle, villas - that's why I turned on record versioning in the first place. But sometimes, occasionally, there is a genuine need to actually delete something to the point that ALL traces are REMOVED - a confidential item that got added by mistake, an item for which you no lo

Re: [web2py] Re: Web2py binaries

2019-10-09 Thread Nico Zanferrari
Hi, see also this issue on the Pyinstaller's site. Could someone kindly try the existing binaries on the new MacOS Catalina (Version 10.15)? Nico Il giorno dom 18 ago 2019 alle ore 09:17 Nico Zanferrari ha scritto: > *Do not update to M

[web2py] Re: I want to delete the file created as a result of an upload field.

2019-10-09 Thread villas
I must confess that I had a sudden feeling of panic on seeing: DELETE xxx FROM yyy ... My experience is there is little or no benefit in deleting records. Record versioning and archiving is the way to go. That is_active field may have a purpose after all! And you can always write a function

[web2py] Re: I want to delete the file created as a result of an upload field.

2019-10-09 Thread 'jim kaubisch' via web2py-users
On Tuesday, October 8, 2019 at 11:30:59 AM UTC-7, jim kaubisch wrote: > > > In several forms I have fields like to one below > > Field('the_file', 'upload' , label=T('Audio File *'), > default = False, > > upl

[web2py] Re: Can't import gluon.contrib.simplejson after migrating to Python 3

2019-10-09 Thread villas
I think we stopped using simplejson some time ago. Just try this: from json import * -- 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 me

[web2py] Can't import gluon.contrib.simplejson after migrating to Python 3

2019-10-09 Thread Lisandro
Hi there! I'm using this version of web2py: Version 2.17.1-stable+timestamp.2018.08.06.01.02.56 I recently moved to Python 3 and I've found this issue. When I try to do this: from gluon.contrib import simplejson ... I receive this error: ModuleNotFoundError: No module named 'decoder' This i

[web2py] Re: PyDAL+MSSQL+FreeTDS: pyodbc.ProgrammingError

2019-10-09 Thread villas
This is the "LIKE predicate escape character". It's harmless, but google it if you wish. https://github.com/web2py/pydal/blob/5a31738a28028392515b26d10a4a87df6a38d7a1/pydal/dialects/mssql.py#L163 FYI please also note: Driver / Unicode Support PyODBC works best with Microsoft ODBC drivers, part

Re: [web2py] a first py4web video tutorial - running on pythonanywhere.com

2019-10-09 Thread villas
Isn't this mainly a CSS issue? Simply make sure you use a mobile-first CSS framework. -- 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 me

[web2py] Re: Db Creation Error Message : Adapter not found for sqLite

2019-10-09 Thread villas
Adapter not found for sqLite Isn't this a capitalisation problem? Should be *sqlite*? I recommend keeping everything as simple as possible. Therefore, place all your code into db.py and dispense with db1.py On Saturday, 28 September 2019 19:30:07 UTC+1, dangeo wrote: > > Hello to All, > >

[web2py] Re: Dropzone app thumbnail error in web2py appliances

2019-10-09 Thread villas
Clearly you are mixing character sets somewhere. This can happen when saving *utf8* characters into a *latin-1* database, for example (or vice versa). Look for any unusual characters (with accents or symbols) in your app, data or even filenames. You can inadvertently introduce the problem by c

Re: [web2py] Re: does having similar controller names or app folder names cause conflict in web2py?

2019-10-09 Thread Rahul Dhakate
All, I tested this scenario can now confirm that it does not have an impact for the issue I mentioned below. Thank you. Rahul On Sun, 22 Sep 2019 at 3:55 PM, Rahul Dhakate wrote: > Hi Massimo, > I appreciate your reply. I had an application where in I had two > controllers one cal

Re: [web2py] When the user gets a ticket error how to trigger some function ?

2019-10-09 Thread Massimiliano
Take a look in scripts directory. There are 2 files: ticket2email.py and ticket2slack.py from where you can take some ideas. On Wed, Oct 9, 2019 at 11:36 AM António Ramos wrote: > Hello i want to implement a sms notifications whenever a user gets an > error ticket. > Is there an event that i ca

[web2py] When the user gets a ticket error how to trigger some function ?

2019-10-09 Thread António Ramos
Hello i want to implement a sms notifications whenever a user gets an error ticket. Is there an event that i can capture to trigger my sms function? regards António -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https: