I am still missing something.
I now have this in model
my_db = DAL('oracle://username/password@Database', migrate_enabled=False)
my_db.define_table('Table1', Field('field1'),
Field('field2'),
Field('Field3'),
)
# The above does not includes all the fields available in the real Table,
just a subset,but with real field names
My controller has this
def display_form():
myquery = (my_db.Table1.field1 == 'Apple')
myset = my_db(myquery)
rows = myset.select()
return locals()
And my view is simply
{{=rows}}
When I click on the link, I get this error:
<class 'cx_Oracle.DatabaseError'> ORA-00942: table or view does not exist
I was expecting to get query result matching Field1 = apple by querying the
real Oracle DB.
What am I doing wrong?
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
