Sorry, I forgot GAE doesn't support Join. I can't think of any other
way except your original one. I heard now mysql is available on GAE.
Maybe you can try if the support join ?
http://googleappengine.blogspot.com/2011/10/google-cloud-sql-your-database-in-cloud.html
On Feb 10, 6:10 am, Saurabh S
Omi, We tried the solution that you have mentioned using join provided
by web2py, it works fine on local server.
But when we run it in google appengine sandbox or deploy it using
google app engine it gives the error "Too many tables in the query".
Is there a solution to resolve this? Is there any
> Also will it possible for me put filters on table 1(say Employees) and> then
> perform join with other tables?
I'm not sure. I think it's more like join then filter.
Something like below...
query = (db.person.id==db.dog.owner) & (db.person.name.like('Omi%'))
rows = db(query).select()
On Feb 9
Thanks Omi.
I will give it a try.
Also will it possible for me put filters on table 1(say Employees) and
then perform join with other tables?
On Feb 9, 7:34 pm, Omi Chiba wrote:
> Sound like you're looping all the records to connect different table.
> I use join for the purpose and working fine
Sound like you're looping all the records to connect different table.
I use join for the purpose 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 3 tables which c
5 matches
Mail list logo