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

2017-05-24 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) - https://code.google.com/p/web2py/issues/l

[web2py] Re: grid edit

2017-05-24 Thread T.R.Rajkumar
When I connect to postgresql the same model the grid edit form submits without error. Is this to do with pyodbc? -- 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 Issue

[web2py] Re: Azure deployment recommendations?

2017-05-24 Thread Dave S
On Wednesday, May 24, 2017 at 7:10:48 PM UTC-7, Brian M wrote: > > I'm looking to try deploying a web2py app on Azure. Is the route mentioned > here still > the best approach? Since running scheduled tasks will be a significant part

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

2017-05-24 Thread Wabbajack
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 After i add a record including an upload file this is the Error Adding record includin

[web2py] Azure deployment recommendations?

2017-05-24 Thread Brian M
I'm looking to try deploying a web2py app on Azure. Is the route mentioned here still the best approach? Since running scheduled tasks will be a significant part of the app, has anybody tried using the web2py scheduler (as a Windows se

[web2py] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch

2017-05-24 Thread Dave S
On Wednesday, May 24, 2017 at 12:06:55 PM UTC-7, Jonathan Calderon wrote: > > Massimo, > > I am using - > > Python 3.6 > DB Driver:cx-Oracle==5.3 > Oracle 11g and 12G > Platform: Windows 7 Ultimate > You're seeing this error with current web2py? (The message you're responding to is 8 years

[web2py] Re: How to force an update to the scheduler schema

2017-05-24 Thread Dave S
On Wednesday, May 24, 2017 at 1:01:14 PM UTC-7, Brad Miller wrote: > > Thanks, that would have been easier. > > What I ended up doing was dropping the tables and removing the table > files. > > then a restart got everything back in sync again. That only worked > because I didn't need to kee

Re: [web2py] Re: jqmobile issue

2017-05-24 Thread Dave S
On Wednesday, May 24, 2017 at 11:38:15 AM UTC-7, Dave S wrote: > > > > On Wednesday, May 24, 2017 at 8:42:02 AM UTC-7, Maurice Waka wrote: >> >> You lost me here. How do I do it. >> > > The answer isn't as obvious as for a desktop browser, it seems. Maybe > this will help: > https://stackoverf

[web2py] Re: How to force an update to the scheduler schema

2017-05-24 Thread Brad Miller
Thanks, that would have been easier. What I ended up doing was dropping the tables and removing the table files. then a restart got everything back in sync again. That only worked because I didn't need to keep any of the data in the scheduler tables. Brad On Tuesday, May 23, 2017 at 1:03:

[web2py] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch

2017-05-24 Thread Jonathan Calderon
Massimo, I am using - Python 3.6 DB Driver:cx-Oracle==5.3 Oracle 11g and 12G Platform: Windows 7 Ultimate -- 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)

[web2py] Re: the ajax callback action return a list [URGENT]

2017-05-24 Thread Anthony
If you are using the ajax() function, note the third argument can be: - ":eval", in which case, you can return Javascript code to be executed (this code could, for instance, define a Javascript array). - A Javascript function, in which case, the returned data will be passed to that f

Re: [web2py] Re: jqmobile issue

2017-05-24 Thread Dave S
On Wednesday, May 24, 2017 at 8:42:02 AM UTC-7, Maurice Waka wrote: > > You lost me here. How do I do it. > The answer isn't as obvious as for a desktop browser, it seems. Maybe this will help: https://stackoverflow.com/questions/5981329/is-there-a-kind-of-firebug-or-javascript-console-debug-f

Re: [web2py] Re: jqmobile issue

2017-05-24 Thread Maurice Waka
You lost me here. How do I do it. One more thing, sorry I just came across this on Google. Instant admin, is it supported? Looks cool or there is an alternative. Kindest regards. On May 17, 2017 8:31 PM, "Massimo Di Pierro" wrote: please try the js console. what is it calling in background? do

[web2py] Re: the ajax callback action return a list [URGENT]

2017-05-24 Thread Leonel Câmara
This is more of a javascript question than a web2py one. If you don't want to display the list in HTML just don't do it, just get the list using $.getJSON or something and do whatever you want to do with it in javascript. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

[web2py] Re: web2py uses deprecated driver to connect to Google Cloud SQL

2017-05-24 Thread Karoly Kantor
In the meantime, I have solved the syntax error above (there was a "-" in the data base name...), and I have successfully connected to a 2nd generation Google SQL instance To do this, i had to hack pyDAL. I would appreciate of someone could look at what I have done, and tell me if this is

Re: [web2py] Re: flash message gets lost

2017-05-24 Thread Yebach
I do not know i it is a bug or smth but if I do not use if form.process().accepted: and just use if form.accepted: Then add_organization(form, userid) is not triggered and also if I put some prints in it I cannot see them in my PyCharm console, while, now this is interesting, e-mail

[web2py] Re: response.download

2017-05-24 Thread Juan Carlos Quesada
This works, thank you Massimo El viernes, 26 de abril de 2013, 18:07:06 (UTC+2), Massimo Di Pierro escribió: > > Please open a ticket about this. The problem is that the roles of > downloading is delegated to the field which stores the upload name. In this > case it was uploaded using a SQLFORM

[web2py] web2py uses deprecated driver to connect to Google Cloud SQL

2017-05-24 Thread Karoly Kantor
I have been unable to connect to a 2nd generation Google SQL instance for quite a time now. This is painful as 1st generation instances are less capable and declared "legacy" by Google. I suspect it may have to do with web2py using a deprecated driver "rdbms", e.g. in google_adapters.py. Accord

[web2py] Suggestion to add in documantation about reference fields

2017-05-24 Thread Tom Clerckx
The web2py documentation indicates that a reference field has the following default validator: IS_IN_DB(db, table.field, format) I suggest the default validator to be described as: IS_IN_DB(db, table._id, table._format) If you use any other field besides *table._id* in the validator, this cause

[web2py] Re: grid edit

2017-05-24 Thread T.R.Rajkumar
I have this in model. db.define_table('amc_master', Field('amcno', type='string',length=10, required='True',notnull='True',requires=IS_LENGTH(10)), Field('unitid',type='string',length=3,notnull='True'), Field('amcdesc', type='string',length=512,requi

[web2py] the ajax callback action return a list [URGENT]

2017-05-24 Thread sunda . amran
Hello, i have a form, when i fill it, it will callback an ajax code, which will call an action, that action returns a list and it puts it on the target, I can see the target when i put And it display the list perfectly ... The problem is that i don't wan't the list being displayed, i just w

[web2py] Re: grid edit

2017-05-24 Thread Dave S
On Tuesday, May 23, 2017 at 11:28:29 PM UTC-7, T.R.Rajkumar wrote: > > Why is DAL trying to update id column in grid edit form submission. > I think we need your model file to have much idea. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com