[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: How to code efficiently for multiple database engines with Exceptions

Hi Joe, psycopg2 installs on mac (I have it on 3). 'pip install' will fail because psycopg2 needs the postgresql client libraries already installed. If you have homebrew just do a 'brew postgresql' followed by 'pip install psycopg2'. It should work. Cheers, Julian On Thursday, September 8,