[web2py] Re: Problem with oracle query

Thanks for posting your solution. I ran into the same problem and probably wouldn't have figured it out without your post. - Tom On Monday, April 15, 2019 at 5:20:36 AM UTC-6, gliporace wrote: > > I think I found the problem: > the query is sent with the table name double-quoted: > > select "an

[web2py] Re: Web2Py and ldap integration

I have used ldap_auth successfully by implementing the following in models/db.py: from gluon.contrib.login_methods.ldap_auth import ldap_auth ... db = DAL('mysql://mydb:mydb@localhost/password') ... # --- end of web2py scaffolding ---

[web2py] Re: please help testing web3py

I installed py4web on centos 7 in a virtual python environment and it works fine. http://127.0.0.1:8000/_dashboard works as advertised, however http://localhost:8000/_dashboard doesn't. When using localhost, the dashboard page comes up, but it won't display any of the installed applications or

[web2py] RSA Securid integration with web2py

Hi, Has anyone integrated web2py authentication with RSA Securid? If you have, I'd appreciate it if you could share the steps you took. - Thanks in advance, - Tom -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: How can I access functions from multiple files in the controllers directory?

Hi, Thanks for your reply. I tried using modules as you suggested. It works great for simple python functions, but when I try to use DAL it dies. It appears that functions in modules aren't aware of the model definitions. Chapter 4 of the manual indicates that I could probably do this by im

[web2py] How can I access functions from multiple files in the controllers directory?

Hi, In the controllers directory I wanted to define some functions in another file. I had hoped to import the functions to make them available to default.py but I haven't been able to get this to work. I'm hoping that someone can point out my error, and possibly a solution. In the controllers

[web2py] Re: Code change in oracle.py to allow joins in pagination.

I downloaded the latest release, 2.14.6, and downloaded my patch file from this post and applied it against oracle.py: cd gluon/packages/dal/pydal/adapters patch < oracle.patch It created the oracle.py I expected and it runs correctly. Are you referring to a different version of web2py? - Tom O

[web2py] Re: Code change in oracle.py to allow joins in pagination.

Hi, I've attached the oracle.patch file for gluon/packages/dal/pydal/adapters.oracle.py - Tom On Saturday, September 24, 2016 at 9:25:06 PM UTC-6, Massimo Di Pierro wrote: > > I can take care of it. Can you email me your patch as an attachment? > > On Friday, 23 September 2016 19:46:34 UTC-5

[web2py] Re: Code change in oracle.py to allow joins in pagination.

> > I'd be happy to give it a try, but I'm not sure what steps to take. When > I go to github and click on create new pull request it appears I have to > select a branch to compare to. I'm uncertain if I am supposed to select > admin, experimental, or enter a value of my own. Does web2py have

[web2py] Code change in oracle.py to allow joins in pagination.

Hello, I have patched the select_limitby routine in oracle.py to allow for successful pagination when joins are used. This is an example of the sql it generates: SELECT c0 "STATUSPOINT.POINTNUMBER", c1 "STATUSPOINT.POINTNAME", c2 "AOR.REFERENCENAME", c3 "AOR.AOR" FROM ( SELECT w_tmp.c0, w_tm

[web2py] Re: SQLFORM.grid problems with Oracle database tables

Nico, Thanks for your response. The tables were already joined in the query definition inside the controller. query = ((db2.STATUSPOINT.POINTNUMBER < 100)&\ (db2.STATUSPOINT.POINTACCESSAREA == db2.AOR.AOR)) I feel quite certain that the problem is associated with the extra SQL requ

[web2py] SQLFORM.grid problems with Oracle database tables

Hi, I have been using SQLFORM.grid to display some legacy Oracle tables. While it works fine when the query is for a single table, as soon as the query involves a join between two tables the grid returns multiple duplicate entries. (I'm using web2py 2.13.4-) The result looks like this: Point

[web2py] Re: Oracle perfomance issues with version 2.12.3

Thanks for the suggestion. I started a web2py session from the command line, and ran a simple DAL select from there. python web2py.py -M -S myapplication result = db2(db2.soe_tdb.pointnumber>0).select(db2.soe_tdb.ALL,limitby=(0,10)) print db2._timings [("ALTER SESSION SET NLS_DATE_FORMAT = '

[web2py] Oracle perfomance issues with version 2.12.3

Hi, I encountered really slow responses when I was using my web2py app to access an oracle database. I tried to use dbstats in response.toolbar to measure this, but it wouldn't show the sql or any timing information. I decided to try downgrading to an older web2py version, 2.11.2, and noticed

[web2py] dbstats with oracle doesn't show sql selects or timing

Hi, I'm using web2py 2.12.3 connecting to oracle 10.2 I tried to use the dbstat function of {{=response.toolbar()}} to examine database performance, but the sql select and its timing isn't printed. This feature works as expected when I'm connecting to a mysql database. Is this a bug, or just

[web2py] Re: what are the12 core objects

- thanks for the response -- 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 subscribed to the Google Groups "web2

[web2py] what are the12 core objects

The preface says that "the API includes just 12 core objects" What are they? - Thanks in advance -- 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 rec