I'm trying to create a new application that will talk with an existing
Oracle database.
In models.py I have the following:
db.define_table('CONSUMED_FILE_STATUSES',
Field('CONSUMED_FILE_STATUS', type='string', length=25),
Field('CONSUMED_FILE_STATUS_DESC', type='string', length=4000),
migrate=False)
This matches the table exactly to what is in the Oracle database. Very
simple table.
I'm able to view the database administration screen without a problem
(seeing this table as a link). The application is connected to the Oracle
database for sure. The problem arises when I want to see the contents of
this table using web2py's database administration.
I get the following error where the query is the following:
db.CONSUMED_FILE_STATUSES.id>0
ORA-00904: "CONSUMED_FILE_STATUSES"."ID": invalid identifier
Any idea what is up? This is the first time I am interfacing web2py with
an existing Oracle database.
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 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.
