now, i know the reason why, thank you so much for your explaination, niphlod.
best regards, stifan On Wednesday, April 9, 2014 4:49:26 AM UTC+7, Niphlod wrote: > > > > On Tuesday, April 8, 2014 2:44:52 PM UTC+2, 黄祥 wrote: >> >> hi, >> >> consider this : >> # e.g. 1 work >> for row in db(db.product).select(): >> print row.rack.branch >> # e.g. 2 not work >> print db(db.product.rack.branch == 1).select() >> >> is it possible to have the example 2 work? >> > > no, you can't. > > db.table.field == something > > is something that can be passed to the underlying db. > > db.table.field.linked_table is something that web2py does recursively > (yep, pretty bad) to pretty print what the database stores as records in > separate tables linked by a FK. > > in your case, you'd need a simple join. > > e.g. > > db( > (db.table.field == db.ref_table.id) & > (db.ref_table.value == 'something') > ).select(db.table.ALL) > > > @Derek: that does exactly what "web2py's" prettyprint does. @all: do > yourself a favour and start embracing moment.js ^__^ > -- 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.