You can select db.mytbl.id*2, but I don't think you can reference the result with an alias -- you'd have to reference it with something like rows[0]['(mytbl.id * 2)']. Of course, for convenience, you could define fld2='(mytbl.id * 2)' and then do rows[0][fld2].
What do you want to do with the results? Anthony On Thursday, September 8, 2011 3:07:55 AM UTC-4, Noel Villamor wrote: > > I am aware about: > tblAlias = db.mytbl.with_alias('tblAlias') > > Is there a similar thing that we can use for fields in select()? > As in: > ... .select( db.mytbl.id, db.mytbl.id*2 as fld2) > > > > >