[web2py] Re: select (field alias)

2011-09-08 Thread Noel Villamor
Your work-around works well Anthony. Thanks. What I intend of doing is querying just a subset of a list:string field (e.g. mytblalias.data[0:6] which in select would appear as: SUBSTR(mytblalias.data,1,(7 - 1)) The field results, however, turned out to be raw with the '|' showing as separators i

[web2py] Re: select (field alias)

2011-09-08 Thread Anthony
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

[web2py] Re: select (field alias)

2011-09-08 Thread Massimo Di Pierro
No. On Sep 8, 2:07 am, 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)