On Tuesday, December 13, 2011 4:33:38 PM UTC-5, Richard wrote: > > Hello Anthony, > > Since my "row" come from a query may I can do something like this (pseudo > code) : > > rows = db((db.lotns_lot_number.id == request.args(1))&\ > (db.lotns_sample.lot_number_id == db.lotns_lot_number.id)&\ > (db[request.args(0)].sample_id == > db.lotns_sample.sample_id)).select\ > (db[request.args(0)].ALL, *HASH_FUNC(db[request.args(0)].ALL)* > orderby=db.lotns_sample.sample_code) > > > In SQL it is pretty common to use Alias for computed field on the fly... I > just don't know if web2py can handle it that way... >
Maybe use a virtual field, which can be applied to a join: http://web2py.com/book/default/chapter/06#Virtual-Fields