Hello,
I am making a web2py application and I have my two mysql tables defined in
my models db.py file:
db.define_table('table1', Field('id','integer'), Field('name','string'),
migrate=False) db.define_table('table2', Field('id','integer'),
Field('name','string'), migrate=False)
I want my application to return a union of these tables:
data=db.executesql('SELECT * FROM table1 union select * from table2;')
in a SQLFORM.grid but apparently
form=SQLFORM.grid(data, create=False, deletable=False, editable=False,
maxtextlength=100, paginate=10)
is not the way to go.
Can somebody help me please?
I stumbled on this:
https://groups.google.com/forum/#!topic/web2py/b5UMpF-3REI
but i didn't really get the solution.
Can someone give me an example?
Thank you
--
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.
