[web2py] Re: Can't open sqlite3 databases.

2021-01-05 Thread 'Woody' via web2py-users
Never mind. It was a dumb issue with a permission in the directory hierarchy where the db files are located. My application is now working fine with Python 3.9 + w2p 2.21. On Monday, January 4, 2021 at 12:03:58 AM UTC-5 Woody wrote: > I updated to Python 3.9 using w2p 2.20.4 and now

[web2py] Can't open sqlite3 databases.

2021-01-03 Thread 'Woody' via web2py-users
I updated to Python 3.9 using w2p 2.20.4 and now I'm getting errors opening sqlite3 databases. This is on an application that had been stable for a long time. Is there a compatibility problem with python 3.9? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://g

[web2py] Re: web2py broken with Python 3.8

2020-01-15 Thread 'Woody' via web2py-users
Good news! I'll give it a try. On Friday, December 6, 2019 at 10:56:48 AM UTC-5, Woody wrote: > > web2py is broken with Python 3.8. I asked a question about this a few days > ago and was told that it would be fixed. Looking at the open issues for > w2p, I don't see open is

[web2py] Re: web2py broken with Python 3.8

2020-01-06 Thread 'Woody' via web2py-users
e is that > stream-like objects are now required to support more methods than they used > to. Another issue I am trying to get to the bottom of has to do with > pickling. I will try fix this over the week-end. It is a priority. > > On Friday, 6 December 2019 07:56:48 UTC-8, Woody wrote: >

Re: [web2py] Re: Web2py with python 3.8.0

2019-11-29 Thread Woody
Shouldn't that be done before the release rather than afterward? -- 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

[web2py] Re: Web2py with python 3.8.0

2019-11-29 Thread Woody
What is causing the problem with Python 3.8? Is it causing problems with other applications? Is it an undocumented bug in Python? Is it likely that Python will be changed to fix the problem or will web2py have to conform to the Python changes? -- Resources: - http://web2py.com - http://web2py.

[web2py] Re: Web2py with python 3.8.0

2019-11-22 Thread Woody
I updated to Python 3.8 on Arch Linux today and I had the same problem with 'escape'. I patched the languages.py file and got web2py to start, but then hit another error: Traceback (most recent call last): File "/home/www/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, env

Re: [web2py] Force boolean to use 1/0 in sqlite?

2013-07-27 Thread Woody
tom-Field-types-(experimental) > > 2. filter_in and filter_out > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#filter_in-and-filter_out > > > Marin > > > On Sat, Jul 27, 2013 at 6:53 PM, Woody >wrote: > >> I have a legacy sqlite3

[web2py] Force boolean to use 1/0 in sqlite?

2013-07-27 Thread Woody
I have a legacy sqlite3 database that is tied to an application that uses 1/0 to represent boolean values. Sqlite doesn't have a boolean data type; 1/0 is the conventional representation. I want to define these fields as boolean in w2p so they will show up as checkboxes in SQLFORM, but when I

[web2py] Re: Inject HTML in field definition

2013-07-18 Thread Woody
Thanks, Massimo. That's a big help! -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://g

Re: [web2py] Inject HTML in field definition

2013-07-18 Thread Woody
iew without LOAD() like that > {{=table}} see what happen. > > Then try SQLFORM.grid or SQLTABLE (that tend to be deprecated, but still > help in many situation where SQLFORM.gris lack of flexibility). > > Richard > > > On Wed, Jul 17, 2013 at 11:46 PM, Woody >wrote: > &

Re: [web2py] Inject HTML in field definition

2013-07-17 Thread Woody
7;)}} On Wednesday, July 17, 2013 11:10:35 PM UTC-4, Richard wrote: > > Can you show us you select and the way you make your table and view? > > Richard > > > On Wed, Jul 17, 2013 at 11:02 PM, Woody >wrote: > >> I don't see 'This is a test'. The ta

Re: [web2py] Inject HTML in field definition

2013-07-17 Thread Woody
**formatted', lambda row: > TAG.span(row.description, _style="color:#EB0F0F;"), > > In case there is no SPAN helper (don't remember if there is SPAN() helper). > > Richard > > > On Wed, Jul 17, 2013 at 5:55 PM, Woody >wrote: > >> 'represen

Re: [web2py] Inject HTML in field definition

2013-07-17 Thread Woody
On Wednesday, July 17, 2013 3:34:21 PM UTC-4, Richard wrote: > > represent!! > > represent=lambda value, row: XML(...) if value is not None else T('N/A') > > Richard > > > On Wed, Jul 17, 2013 at 3:24 PM, Woody >wrote: > >> I have a table defini

[web2py] Inject HTML in field definition

2013-07-17 Thread Woody
I have a table definition that uses virtual fields with XML: db_mydb.define_table('my_table', Field('ROWID', 'id'), Field('location', 'string'), Field('description', 'string', required=False), Field.Virtual('description_formatted', la

[web2py] Re: How to insert line breaks in table cell created by a virtual field

2013-07-15 Thread Woody
Perfect! That did the trick. On Monday, July 15, 2013 4:39:05 AM UTC-4, Massimo Di Pierro wrote: > > Try this: > > db.table.field = Field.Virtual('alert_time', > lambda row: XML(str( integer>) + ' hours' + str( datetime>))) > > On S

[web2py] Using ROWID function as id field in sqlite tables

2013-07-14 Thread Woody
This may be something that is known by people with more experience than me, but it took me a lot of experimenting to figure it out, so I thought I would post it here so others will find it. I have legacy sqlite tables that do not have an id field. This makes it difficult to update them using S

[web2py] How to insert line breaks in table cell created by a virtual field

2013-07-14 Thread Woody
I have a virtual field that concatenates 2 fields like this: Field.Virtual('alert_time', lambda row: (str() + ' hours' + str()) The result goes into a table cell and looks something like this: "8 hours 2013-07-14 09:10:20" I want to force line breaks so that it will look lik

[web2py] Re: Field.Virtual does not show up in db.table.fields

2013-07-14 Thread Woody
future version? * * On Sunday, July 14, 2013 5:18:26 AM UTC-4, Massimo Di Pierro wrote: > > No. This is the intended behavior. > > > > On Saturday, 13 July 2013 12:27:04 UTC-5, Woody wrote: >> >> I'm using version 2.5.1 stable and I've created a vir

[web2py] Field.Virtual does not show up in db.table.fields

2013-07-13 Thread Woody
I'm using version 2.5.1 stable and I've created a virtual field as part of a table definition, like this: db_mydb.define_table('my_table', Field('ROWID', 'id'), Field('test_field1', 'string', required=True), Field('test_field2', 'string', required=F

[web2py] Re: LOAD gives duplicate navbar

2013-07-07 Thread Woody
That's just what I needed. Thanks much for the help. Web2Py is a great development platform, and I really appreciate all of the generous help provided by people on this list! On Saturday, July 6, 2013 9:36:28 PM UTC-4, Anthony wrote: > > {{=LOAD('default','select_table',args=("x10_state_view",

[web2py] LOAD gives duplicate navbar

2013-07-06 Thread Woody
I have an index.html that looks uses LOAD to call a function which returns a table. Here's the code for index.html: {{extend 'layout.html'}} Current State {{=LOAD('default','select_table',args=("x10_state_view", "not_editable"),ajax=True, target='table')}} Everything looks good, except t

[web2py] Re: Can view, but can't edit files

2013-07-03 Thread Woody
Okay, I'm still struggling with this. I opened up ports on my router, so now I'm accessing w2p admin using https from the outside world. Admin functions seem normal, except that editing files is extremely flaky. I can open a file and edit it once, but the next file I open gives a communicat

[web2py] Re: How to get a list of all fields in a table?

2013-06-28 Thread Woody
Perfect! Thanks. On Thursday, June 27, 2013 4:43:07 PM UTC-4, Niphlod wrote: > > tables list = db.tables > field list for table 'a_table' = db.a_table.fields > > > > On Thursday, June 27, 2013 10:30:24 PM UTC+2, Woody wrote: >> >> I hope the answer to th

[web2py] How to get a list of all fields in a table?

2013-06-27 Thread Woody
I hope the answer to this is something that's not too obvious, but I've searched a bit and have not found an answer. I'm looking for a way to programatically get a list of all of the fields in a given table. My intention is to build a common function that will use variables for table names an

[web2py] Re: Can view, but can't edit files

2013-06-26 Thread Woody
Let me clarify. The server is a headless system (actually, a small plug computer). So, I can access it like this: Local LAN PC#1: 192.168.xxx.111 -> Server: 192.168.xxx.222 . This works ok. Now, when I ssh tunnel to PC#1 or to Server, I can go to URL: https://192.168.xxx.222/admin or https:/

[web2py] Re: Can view, but can't edit files

2013-06-24 Thread Woody
the "other" > version of admin's static files. > > On Friday, June 21, 2013 6:27:46 PM UTC+2, Woody wrote: >> >> I am using web2py admin served by nginx and uwsgi. When I access the >> server from the same LAN, I can edit files with no problem. When I use

[web2py] Can view, but can't edit files

2013-06-21 Thread Woody
I am using web2py admin served by nginx and uwsgi. When I access the server from the same LAN, I can edit files with no problem. When I use an ssh tunnel to proxy into my LAN from a remote location, I can login to the admin app and I can view files, but when I try to edit them, I get nothing