[web2py] Re: best way to fetch data from multiple tables?

2012-02-09 Thread Sonal_b
and working fine though I only have about > 1 records. > > http://www.web2py.com/books/default/chapter/29/6?search=join#Inner-joins > > On Feb 9, 8:19 am, Sonal_b wrote: > > > > > > > > > I have to query 3tableswhich contains large number ofda

[web2py] best way to fetch data from multiple tables?

2012-02-09 Thread Sonal_b
I have to query 3 tables which contains large number of data I have to come up with report which displays Employee Firstname, Lastname, Manager's FirstName, Manager's Lastname and Organisation name. Table Structure/Details: 1. Employee table: which contains employee information(First name, last

[web2py] Insert/Retrieve data to/form Google Spreadsheet

2012-01-30 Thread Sonal_b
I would like to know if it is possible to insert/retrieve data to/from Google Spreadsheet using Web2Py framework. In case yes, what all changes are required to be done at the code level. Also any specific configurations required to achieve the same?