I have a question about db.table.ALL

In case of:

db(db.table1.id>1).select(db.table1.ALL)

this:

db(db.table1.id>1).select()

gives the same result.


In case of:

db((db.table1.id>1)&(db.table1.refID==db.table2.id)).select(db.table1.ALL,db.table2.ALL)

this:

db((db.table1.id>1)&(db.table1.refID==db.table2.id)).select()

also gives the same result, however, the moment I replace ALL with a field 
name, I no longer get ALL fields from table2

db((db.table1.id>1)&(db.table1.refID==db.table2.id)).select(db.table1.id)


Is this correct, and can I leave out the .ALL expression when I need all 
the fields from the joined tables, or
does ALL have a function in this case?


Kind regards,

Annet

-- 

--- 
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/groups/opt_out.


Reply via email to