[web2py] Re: Is web2py incompatible with 2nd generation Google Cloud SQL ?

2017-05-25 Thread Karoly Kantor
I have temporarily solved this problem, as described here: https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] styling smartgrid New/Edit/View forms

2017-05-25 Thread icodk
Background My model has a table with many fields (62). When using smartgrid to edit or add a record, all fields are shown in a long vertical list in the same order as defined in the model. So log so good. This can be overwhelming to user that might need to see some of the fields very often and

[web2py] Re: grid edit

2017-05-25 Thread T.R.Rajkumar
I googled and saw this https://www.drupal.org/node/2342699 where it is stated that SqlContentEntityStorage::mapToStorageRecord sends update statements that includes IDENTITY fields that need to be updated, such as: UPDATE xxx SET nid = 1, property0 = :value0 WHERE nid = 1;. This is not

[web2py] -K startup

2017-05-25 Thread Dave S
I've finally put my fingers on certbot, and have my 443 responding (now I'm a good boy). This server hosts 2 applications, each of which runs a scheduler. For various reasons, I do my -K's separate from the main listening process. It occurred to me to wonder, as I did the start/restart

[web2py] Problems with file uploading using FORM

2017-05-25 Thread Maurice Ling
Hi everyone, I am stuck with an issue - please refer to the code below. 1. I have a form (new_entry function) that I will like to use to be able to upload a file among other fields. 2. I am using FORM instead of SQLFORM because one of the dropdown fields (line 11) in the form is generated at

[web2py] Re: Codec MS-SQL, unicode Latin1 UTF8

2017-05-25 Thread tim . nyborg
I use this same stack, and ran into encoding issues when updating the database, because of FreeTDS v.91. But upgrading to FreeTDS v1.00.40 fixed all unicode issues: https://github.com/mkleehammer/pyodbc/issues/244 Connect with mssql4n, TDS_Version 7.1+, no need to set db_codec On Friday, 19

[web2py] Re: styling smartgrid New/Edit/View forms

2017-05-25 Thread Anthony
You could create a custom formstyle function and then pass it to the grid via the "formargs" argument or set response.formstyle. Anthony On Thursday, May 25, 2017 at 4:50:58 AM UTC-4, icodk wrote: > > Background > My model has a table with many fields (62). When using smartgrid to edit > or

[web2py] Re: Azure deployment recommendations?

2017-05-25 Thread Brian M
Yes, if necessary I could run a Linux VM in Azure but since everything else is Windows based just sticking with that would be easiest. We could go for a full Windows VM in Azure too but I was hoping to be able to give it a go with the Web App Service and not have to worry about maintaining the

[web2py] Re: Field('upload') : problem with file name

2017-05-25 Thread Dave S
On Wednesday, May 24, 2017 at 9:37:17 PM UTC-7, Wabbajack wrote: > > Hi Massimo, > > Still has this issue... :( > > I am using 2.14.6 web2py running in windows7 with pydal 17.03 and python > 2.7 > > > I have this filename 54 characters (including '.pdf ') > > > > > This is the field on my db.py

[web2py] Re: Problems with file uploading using FORM

2017-05-25 Thread Dave S
On Thursday, May 25, 2017 at 8:34:44 AM UTC-7, Maurice Ling wrote: > > Hi everyone, > > I am stuck with an issue - please refer to the code below. > > [...] > 5. I will the want to copy the file into application//upload > folder using shutils (lines 17-25) but the file name will be changed to