This is the query:
query = (db1.ana_paz.COGNOME==form.vars.cognome.upper())
if form.vars.nome:
query = query & (db1.ana_paz.NOME==form.vars.nome.upper())
if form.vars.data_nascita:
query = query & (db1.ana_paz.DATAJ_NAS==form.vars.data_nascita)
try:
rows = db1(query).select()
except:
response.flash = "Errore nella ricerca anagrafica, procedere
all'inserimento manuale delle informazioni."
A raw query with db1.execute() works ok instead.
Hope someone could me :)
Gianfranco.
Il giorno venerdì 12 aprile 2019 17:00:14 UTC+2, gliporace ha scritto:
> Hi,
> I just updated my web2py installation from 2.11 to 2.18.5, but the apps
> who make use of cx_Oracle for connecting to a Oracle database show this
> error
> when ther try to query a table/view:
>
> Exception ORA-00942: table or view does not exist
>
> The old web2py installation run without problems on a Ubuntu server 14.04
> and cx_Oracle 5.3, the new installation is on Ubuntu server 16.04 with the
> same version of cx_Oracle.
>
> Is there any means to check what is the query before is sent to the server?
>
--
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
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
