[web2py] Output format of an SQL query

2016-05-28 Thread Sammy
I am a python/web2py newbie. I am trying to create a user friendly web search form for clients that connects to our existing Oracle DB and executes a query based on search criteria put in the form by users. For example, user will fill out the form saying first_name = "John" , last_name="Smith"

[web2py] Re: web2py 1.89.5

2016-05-28 Thread Roman Molotkovski
Well, one of our previous developers edited some of the files within the gluon folder years ago in order to add some functionality that we rely on. Why he couldn't add that functionality outside of the gluon folder is beyond me. The bottom line is that we need a "clean" copy of gluon from versi

[web2py] Re: Localize JavaScript

2016-05-28 Thread Jeff Riley
All, Ok I think this would help my situation, but I am missing how to execute the Ajax. I have four views that contain the same javascript and would really like to move to the static js folder, but the javascript requires elements passed to the views from the controllers. The "Drawtext" item

[web2py] Re: LOAD with ajax=True not working with SSL

2016-05-28 Thread Anthony
Does it work if you load the exact same URL as the main page (i.e., without Ajax)? On Saturday, May 28, 2016 at 1:56:30 PM UTC-4, Tom Øyvind Hogstad wrote: > > Everything looks okay. It's a bit challenging to experiment on a live > server, so I will look more into it when time permits me to set

[web2py] nginx and uploads

2016-05-28 Thread 'Annet' via web2py-users
I installed Web2py at Webfaction. In Web2py I have an application dbmodel that contains my models, static files and uploads. I created two static only applications one two serve the content of static and one to serve the content form uploads. So any request starting with http://www.domain.com/d

[web2py] Re: LOAD with ajax=True not working with SSL

2016-05-28 Thread Tom Øyvind Hogstad
Everything looks okay. It's a bit challenging to experiment on a live server, so I will look more into it when time permits me to set up SSL on a test environment. Really not concerned about security, but I discovered Google Chrome won't permit use of the browser geolocation functions unless th

[web2py] Re: Setting up the scheduler, and letting it run from a certain point of time

2016-05-28 Thread Mohit Jain
I am stuck with a similar situation here. I have the models/scheduler.py from gluon.scheduler import Scheduler def auto_insert(): try: db.UserLogs(user_name='temp',user_email='a...@as.com',activity='checking scheduler') return 'inserted' except: return 'failed'

[web2py] Re: readonly field only in SQLFORgrid edit page if field is not empty

2016-05-28 Thread Mike Constabel
Am Freitag, 27. Mai 2016 06:48:31 UTC+2 schrieb Anthony: > > def list_order_type(): > if 'edit' in request.args: > record = db.foobar(request.args(-1, cast=int)) > older_than_an_hour = record.created_on < request.now - datetime. > timedelta(hours=1) > db.foobar.text.wr